IT Developer
- Verfügbarkeit einsehen
- 0 Referenzen
- 50€/Stunde
- 82049 Großhesselohe, Isartal
- auf Anfrage
- en
- 20.06.2017
Kurzvorstellung
Qualifikationen
Projekt‐ & Berufserfahrung
2/2017 – 3/2017
Tätigkeitsbeschreibung
• Managing the operations on SQL and providing support for databases - creating and maintaining databases on production/development servers using Microsoft Azure
• Optimisation and monitoring of database servers - capacity planning and performance.
• Involved in database migrations from Standalone to Azure cloud.
• Management and maintenance of data, including backups, data fixes, replication, restoration and high availability of operational systems using Microsoft Azure
• Working within the framework of corporate standards and policies, contributing to the ongoing development, particularly in change management and change control.
• Implemented scripts to find out the orphan users in the servers and successfully migrated logins and users between multiple servers.
• Monitoring the data files, log file space issues, blockings, Tempdb space issues and disk space issues.
• Provided On-Call support to Mission Critical Environments and expertise with Disaster Recovery mechanisms.
• Performing SQL database upgrades as needed for improvement and maintenance of the databases including rollout and upgrades.
• Responsibility for data integrity with the applications development staff, including a deep understanding of Relational Database Management principles
Environment: SQL Server 2014/2016, Windows 2012, Windows 2016.
Microsoft SQL-Server (MS SQL)
5/2014 – 1/2017
TätigkeitsbeschreibungI have been working as an Operations lead with team size of 10, we work with managing databases with multiple technologies (SQL, Oracle, Mongodb & Mysql). I am involved in multiple ETL & Reporting projects.
Eingesetzte QualifikationenMicrosoft Business Intelligence (BI), Transact-SQL (T-SQL), Microsoft SQL Server Reporting Services (SSRS), Oracle Business Intelligence (BI), Oracle Database, mySQL, MongoDB, ETL, Microsoft SQL-Server (MS SQL)
2/2013 – 4/2014
TätigkeitsbeschreibungI have 9+ years in Server Database Administration with extensive hands-on experience in providing operational and developmental support for all production and non-production databases. Vast exposure in performing backup and recovery on database management systems, configuring database parameters, monitoring and maintaining system capacity, data security, systems documentation and systems management tools.
Eingesetzte QualifikationenMicrosoft Business Intelligence (BI), Oracle Database, mySQL, MongoDB, Microsoft SQL-Server (MS SQL)
3/2011 – 1/2013
Tätigkeitsbeschreibung
• Installing & configuring SQL Server 2005/2008 and 2012 on windows 2003/2008 and 2012 servers, applying service packs and security fixes for individual servers & clusters.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Working with customers on Application rollouts and server migrations.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory
• Involved in database migrations within different Data centres.
• Day-to-day activities like taking backups, restoring the databases, custom code deployment.
• Implemented and maintained Database Mirroring, Log shipping and Transactional Replication as Disaster Recovery/High Availability solution.
• Provided On-Call support to Mission Critical Environments and expertise with Disaster Recovery mechanisms.
• Performing SQL database upgrades as needed for improvement and maintenance of the databases including rollout and upgrades.
• Responsible for ensuring that production SLAs are met, upgrades are delivered without disruption
• Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, Connectivity issues and Security issues etc.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Responsibility for data integrity with the applications development staff, including a deep understanding of Relational Database Management principles to logically design normalized relational data models and table structures.
• RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005/2008/2012
• Upgrading and patching the instance of development environment and production of SQL Server 2005 service to SQL Server 2008 and SQL server 2008 SP3.
Microsoft SQL-Server (MS SQL)
9/2007 – 3/2011
Tätigkeitsbeschreibung
• Managing the operations on SQL and MySQL databases for HP, providing 24*7 supports for databases - creating and maintaining databases on production/development servers.
• Optimisation and monitoring of database servers - capacity planning and performance.
• Management and maintenance of data, including backups, data fixes, replication, restoration and high availability of operational systems.
• Installing & configuring SQL Server 2005/2008 and 2012 on windows 2003/2008 and 2012 servers, applying service packs and security fixes for individual servers & clusters.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Working with customers on Application rollouts and server migrations.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory
• Involved in database migrations within different Data centres.
• Day-to-day activities like taking backups, restoring the databases, custom code deployment.
• Implemented and maintained Database Mirroring, Log shipping and Transactional Replication as Disaster Recovery/High Availability solution.
• Provided On-Call support to Mission Critical Environments and expertise with Disaster Recovery mechanisms.
• Performing SQL database upgrades as needed for improvement and maintenance of the databases including rollout and upgrades.
Microsoft SQL-Server (MS SQL)
Zertifikate
Ausbildung
India
Über mich
Weitere Kenntnisse
Persönliche Daten
- Englisch (Muttersprache)
- Europäische Union
Kontaktdaten
Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.
Jetzt Mitglied werden