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 SKILLS

Database(s): MS SQL Server 2000/2005/2008/2008 R2, 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 EXPERIENCE

Confidential

Technical Lead

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 Confidential 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

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 Confidential Media segment.

Confidential

Technical associate

Responsibilities:

• Implemented Mirroring for Confidential HealthCare critical systems from one Pole to another pole.
• Configured Transactional Replication between Milwaukee to China.
• Administered a 1.2 TB of database for Confidential 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

Responsibilities:

• 24/7 On-Call Production support and managed 1500 servers from different poles.
• Administered Max size of database for Confidential 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.

Confidential

Technical Specialist

Responsibilities:

• 24/7 On-Call Production support.
• Administrate 900GB of database for Confidential .
• Implemented Mirroring for Confidential .
• Manage 450 servers from different locations and from different GEO’s.
• Manage database instances, monitor server performance, fine tune database server and applications, and perform backup and recovery.
• Extensively used DMV’s and configured search mechanism by using Full text Catalogs.
• Optimized Performance of SQL Queries by using DTA tool and 3rd Party tools.
• Perform day to day Database Maintenance tasks, Backups, Space Management, Rebuild Statistics for all production database Servers.
• Maintained Database Documentation.
• Created logins and maintained user permissions appropriately.
• DB refreshing to Production to development environments.
• Performed DBCC checks and fixing data corruption in Application databases.
• Created network aliases as per business requirements.
• Developed SQL Server database stored procedures and functions to process business rules and data logic.

Confidential

SQL Team Member

Responsibilities:

• Worked on Database Maintenance, Backups and Recovery Plans.
• Monitor SQL Error Logs/ Schedule tasks/data activity/ eliminate blocking and deadlocks/ user counts and connections/ locks.
• Configured servers under monitoring by using SQL DM.
• Involved in the configuration, implementation and oversight of routine database maintenance jobs, such as re-indexing and index defrag, integrity checks, data / log file shrinks.
• Configured Disaster Recovery sites as per plan using Mirroring.
• Configured linked servers between SQL Server databases to DB2 destination.
• Implemented Log shipping for report purpose and as well DR setup.
• Experience in Agile (Scrum) SDLC methodologies.
• Good in Database Documentation.
• Enabled SQL agent service notifications for job failures.
• Installed SQL Server instances on different windows boxes using Split stream installation.

Confidential, Sacramento, CA

SQL Team Member

Responsibilities:

• Maintained 20 servers and created logins, database users and assigning roles.
• Configured Mirroring and Replication between different sites.
• Plan and implement backup, recovery strategy and used maintenance plans for the databases.
• Migrated Oracle database to SQL using SQL Server Migration Assistant (SSMA).
• Developed HTML Web pages and incorporated with .Net pages, configured Web site under IIS 6.0.
• Maintained and managed documentation for Database environment.
• Written stored procedures and cursors as per business logic.

Confidential

SQL Team Member

Responsibilities:

• Managed Max size databases and Involved in Performance Tuning by using DTA tool.
• Installed & Configured Database Mirroring between two poles on SQL Server 2005.
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
• Experience reading, writing and Debug code written in VB.NET & C#.Net in a Web Based environment.
• Created regular backups of databases and transaction logs using SQL Safe- IDERA.
• Configured database monitoring under SQL Diagnostic Manager ( SQL DM).
• Document database environment and pulled out reports by using SSRS.
• Ensured all database servers are backed up properly, and backups are tested.