Lead MS SQL Server DBA - Oracle DBA Summary

A certified IT professional with over 9 years' experience in various technologies such as databases and it systems. Worked in various domains such as healthcare, finance, auditing SOX, PII, HIPAA PCI databases , media/entertainment applications and oil gas.

• Experience in 24x7 production support and worked on On-call escalations.
• Experience working in SQL Azure databases.
• Experience in RDBMS database design, performance tuning, optimization, Profiler, backup and recovery in SQL Server 2000/ 2005/2008/2008 R2, 2012 2014.
• Solid experience in 3rd party Tools IDERA SQL Diagnostic Manager, SQL Safe SQL Secure , Light Speed, Foglight, Double Take, Cyber-Arc and Service Now.
• Experience with different databases like Oracle 10g, 11g, 12c in multiple OS environments like Windows, UNIX, Linux, AIX, Oracle Solaris and VMware Environments.
• Performing Cloning and Refresh Oracle databases.
• Acted as a SQL Server implementation consultant, administration, management and maintenance, SQL Server installation, Migrations up gradations including high-availability cluster configurations on Windows cluster 2003, 2008 2012 and SQL server cluster.
• Extensive experience creating and maintaining SQL Server objects. Database monitoring and optimization.
• Expertise in implementing Oracle Data guard.
• Developed and supported ETL processes using DTS, SSIS, or Microsoft .NET programming using SQL Server Management Studio, ETL process using tools like BULK INSERT and BCP.
• Experience handling databases in large scale environments with max size 2 TB.
• Exposure on Logical Backup and Physical Backup schedules using Import/Export, Data pump and RMAN.
• Extensive experience in implementing logical model into Physical SQL Server Database and creating SQL table and triggers using scripts.
• Good knowledge in Client and Oracle Database Up gradation and CPU Patching.
• Experience in Replication, Mirroring and log shipping between different Servers from different sites on different versions SQL 2005/2008/2008 R2/2012 and Configured Database disaster setups.
• Experience in implementing and managing the security of SQL database environment access/authentications , Roles and user permissions.
• Designed database capacity planning and Management.
• Good experience on HP Service Manager, HP Support Central BMC Remedy.
• Configured Monitoring using SQL Diagnostic Manager, Tivoli, HP OVO and Oracle Enterprise Manager OEM and SCOM.
• Skilled in stored procedures, User Defined Functions, triggers, views, Full Text Search Catalogs and Strong Performance monitoring, logs reading, index tuning and troubleshooting skills.
• Fine/performance tuning SQL Queries and Stored Procedures using Data Tuning Advisor DTA and worked on optimization of the stored procedures and created indexes on the required tables. Created distributed partition views, indexed views.
• Experience in linked servers setup to run distributed queries and transactions between SQL servers and from different RDBMS databases.
• Experience in using Data Transformation Services DTS and SSIS to import data from many different platforms to SQL Server.
• Worked with SQL Server 2005 and SQL Server 2008 SSRS and created various reports using SQL Server reporting service SSRS and created cubes using SQL Server 2005 analysis service SSAS .
• Experience in Troubleshooting Techniques and Resolving Issues On Standalone, MS Clusters and HP Poly Serv.
• Monitoring SQL server Agent jobs and responding to SQL server notifications.
• Comprehensive knowledge in providing suggestions of using best RAID V-Blocks Technologies based on application requirement.
• Thorough understanding of the Requirements, Suggesting Change Requests CRs Enhancements.
• Expertise in various MS SQL High Availability technologies like AlwaysOn, Replication, Log Shipping, Failover Clustering including when to use one method over another, limitations, and alternatives.
• Build database tools and scripts to automate where possible.
• Experience in Documentation.
• Work with the various Engineering groups and ensure database changes are in-line with operational standards and meet the strategies needed to scale while maintaining a scalable, reliable, and robust database environment.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

Technical Skill Set

Database s MS SQL Server 2000/2005/2008/2008R2, 2012 and 2014, Oracle 10g Oracle 11g. Database Tools SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Data transformation Service tools, ISQL, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, T-SQL, SQL Client Configuration utility, Oracle Data Guard, SSIS, SSRS, IIS 6.0. Operating Systems Windows 2012/2008/2003/2000 server, Windows NT and XP, Windows 95/98. Languages T-SQL, C , .Net, HTML. Reporting Tools MS Excel, SQL Server Reporting Services, OSQL Scripts. Other Tools SQL Diagnostic Manager, SQL Safe, SQL Secure, Cyber-Arc, HP polyserv, Foglight, Service Now, Windows Cluster and Visual Source Safe VSS .

Professional experiences

Confidential

Technical Lead

Team Size 18

Operating Systems Windows 2012/2008/2003

Databases MS SQL Server 2000/2005/2008, and 2012

Tools Techniques SQL Profiler, SQL Query Analyser, Index Analyser, ISQL, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, T-SQL, SQL Client Configuration utility, HP Open View HP OVO , Tivoli 5.6, Oracle Enterprise Manager OEM , HP Service Manager, SSIS and VERITAS Cluster.

Roles Responsibilities:

• Was always available for production support 24/7 On-Call .
• Played a key role in database DB Size 2 TB administration for WDPR.
• Implemented Mirroring for Walt Disney Parks Resorts critical systems.
• Managed 3000 servers and database instances, monitor server performance, fine tune database server and applications, and perform backup and recovery by using SQL Native.
• Resolve SQL Server performance issues and experienced in query optimization, index tuning.
• Configured monitoring for WDPR segment servers under Oracle Enterprise Management OEM .
• Performed day to day Database Maintenance tasks, Backups, Space Management, Rebuild Statistics for all production database Servers.
• Configured SQL instances under Tivoli, Foglight HP OVO monitoring.
• Utilized OSQL script for Automatic backup report for Production databases.
• Document database environment and kept in document repository.
• Installed and Configured SQL Server 2005, 2008, 2008 R2 and 2012 versions on MS Clusters.
• Experience in Agile Scrum SDLC methodologies.
• Applied SQL patches on MS Cluster SQL Instances and Mirrored databases.
• Taking database backups and recovery using RMAN on Oracle databases.
• Database Cloning from Production to QA and DEV Environments on Oracle databases.
• Installation/Up gradation of Database and Client Software Configured Database Mirroring Log shipping for DR reporting purpose.
• Established Transactional replication between Orlando to China Databases.
• Implemented Minimum Security Base lines on PCI PII data base instances and Configured SPN's for service accounts.
• Implemented AlwaysOn for WDPR segment servers.
• Experience with SharePoint as a repository.
• Upgraded SQL server license on CAL based system and used V-Block technologies for database restore.

Confidential

Senior Technical Specialist

Team Size 9

Operating Systems Windows 2012/2008/2003

Databases MS SQL Server 2000/2005/2008, and 2012

Tools Techniques SQL Profiler, SQL Query Analyser, Index Analyser, ISQL, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, T-SQL, SQL Client Configuration utility, HP Open View HP OVO ,HP Service Snow , and VERITAS Cluster.

Roles Responsibilities:

• 24/7 On-Call and administered File service management services large databases.
• Supported 1500 servers from different GEO's and configured Mirroring and Transactional Replication as part of Disaster recovery procedure.
• HP Open View is used for Data base monitoring and alerting system.
• Implemented Oracle Data Guard for Production databases.
• Performed day to day Database Maintenance tasks, Backups, Space Management, Rebuild Statistics for all production database Servers.
• Installed SQL Server 2008, 2008 R2 and SQL Server 2012 on MS cluster for Active-Active and Active-Passive environment.
• Experience with SharePoint as a repository services.
• Developed OSQL script for Disk free space report for Critical systems and it will send email to customers.
• As per vulnerability management applied SQL Patches on Standalone and MS Cluster servers.
• Configured SPN's for service accounts as per MSB controls from compliance and experienced on Kerberos Configuration.
• Document database environment.
• Used Double Take for disk level mirroring in Disney Media segment.

Confidential

Technical associate

Team Size 12

• Operating Systems Windows servers 2008/2003/2000
• Databases MS SQL Server 2000/2005 / 2008 and 2008 R2
• Tools Techniques SQL Profiler, SQL Query Analyser, DTA, OSQL, CMS Central Management Service , Replication server, SQL Agents, SQL Alerts, SQL Jobs, T-SQL, SQL Diagnostic manager SQL DM ,SQL Safe , SQL Secure, Cyber-Arc, HP Support Central

Roles Responsibilities:

• Implemented Mirroring for GE HealthCare critical systems from one Pole to another pole.
• Configured Transactional Replication between Milwaukee to China.
• Administered a 1.2 TB of database for GE HealthCare and was available 24/7 On-Call Production support. Also Managed 2500 servers from different poles.
• Troubleshoot SQL Server service outages as they occur, including after-hours.
• Managed database instances, monitor server performance using SQL DM, fine tune database server and applications, and perform backup and recovery by using SQL Safe IDERA tools.
• Performed day to day Database Maintenance tasks, Backups, Space Management, Rebuild Statistics for all production database Servers.
• Performing Cloning and Refresh on Oracle databases.
• Documented database environment and Experience in Agile Scrum SDLC methodologies.
• Scheduled backups and performed restore operations for system test data depends on Change Requests/ Workflow Requests. Configured Linked servers for Cross platform Oracle DB2 databases .
• Established logins and maintained user permissions appropriately. Implemented Minimal Security Base line controls on PCI data bases instances and setting up Kerberos.
• Migrated machine critical databases in less span of down time using database Mirroring.
• Worked on increase performance including hardware purchases, server configuration changes.
• Migrated Oracle databases to SQL Database using SSMA.
• Developed Stored Procedures, views and full text indexes and fine tuned database queries with the help of Database Tuning Advisor DTA .

Confidential

Technical Specialist

Team Size 9

Operating Systems Windows servers 2008/2003/2000

Databases MS SQL Server 2000/2005 / 2008 and 2008 R2

Tools Techniques SQL Profiler, SQL Query Analyser, DTA, DTS Data transformation Service tools, OSQL, CMS Central Management Service , Disaster Recovery setups, SQL Agents, SQL Alerts, SQL Jobs, T-SQL, SQL Diagnostic manager SQL DM , SQL Safe , SQL Secure, Cyber-Arc, HP Support Central

Roles Responsibilities:

• 24/7 On-Call Production support and managed 1500 servers from different poles.
• Administered Max size of database for GE Oil Gas.
• Implemented Log shipping mirroring for critical systems by considering risk management disaster recovery plan and Configured Transactional Replication between different data centers.
• Managed database instances, monitor server performance, fine tune database server and applications, Index fine tuning, and perform backup and recovery by using SQL Safe - IDERA tool, Light speed.
• Performed day to day Database Maintenance tasks, Backups, Space Management, Rebuild Statistics for all production database Servers and configured agent alerts when job fails.
• Scheduled backups and performed restore operations for system test data depends on RFC's.
• Configured Linked servers Network aliases and created logins and maintained user permissions appropriately and implemented MSB's practices tightly aligning with Security controls and implemented Minimal Security Base on PCI data bases instances.
• Data base refreshing to development environments.
• Migrated databases from one version to another version and applied security patches as per vulnerability management process.
• Developed Stored Procedures, views and Cursors as per business requirements and reviewed Performance Tuning with the help of DTA.
• Documented database environment and RCA for Priority 1 Priority 2 tickets on database outages.