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 in RDBMS database design,performance tuning, optimization, Profiler, backupand recovery in SQL Server 2000 and SQL Server 2005/2008/2008 R2 & 2012.
• Solid experience in 3rd party Tools IDERA (SQL Diagnostic Manager, SQL Safe & SQL Secure), Light Speed.
• Acted as a SQL Server implementation consultant, administration, management and maintenance. SQL Server installation and upgrades including high-availability cluster configurations.
• Extensive experience creating and maintaining SQL Server objects. Database monitoring and optimization.
• Expertise in implementing disk level mirroring by using Double Take.
• 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.
• Worked in installing, upgrading and configuring MS SQL Server. Proven skill in Database Migrations.
• Extensive experience in implementing logical model into Physical SQL Server Database and creating SQL table and triggers using scripts.
• Experience in Replication, Mirroring and log shipping between different Servers from different sites on different versions SQL 2005/2008/2008 R2/2012
• Configured Database disaster setups for different machine critical applications.
• Experience in implementing and managing the security of SQL database environment (access/authentications), Roles and user permissions.
• Designed database capacity planning and Management.
• Expertise on password repository tool Cyber-Arc.
• 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), SCOM.
• Implemented Search Engine Techniques using Full Text Search Catalogs
• Skilled in stored procedures, User Defined Functions, triggers, views.
• Strong Performance monitoring, logs reading, index tuning and troubleshooting skills.
• Fine/performance tuning SQL Queries and Stored Procedures using Data Tuning Advisor (DTA)
• Extensively 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 2008 SSRS and created various reports using SQL Server reporting service (SSRS).
• Experience in creating cubes using SQL Server 2005 analysis service (SSAS).
• Experience in Troubleshooting Techniques and Resolving Issues On Standalone, MS Clusters and HP Poly Serv.
• Expertise on HP Poly Serv cluster implementation and Virtualizations. Also worked on resolving Blocking and Dead locks.
• Experience in Clustering, Replication, Data Modeling (Physical and Logical), Data Mapping.
• Monitoring SQL server Agent jobs and responding to SQL server notifications.
• Experience working in Azure SQL databases
• Experience in creating packages using DTS and SSIS and deployed on servers.
• Experience in Scheduling Jobs using SQL Agent and SQL Safe.
• Written skills in T-SQL language, stored procedures, functions, views, triggers, and cursors
• Comprehensive knowledge in providing suggestions of using best RAID Technologies based on application requirement.
• Experience in implementing different backup and recovery strategies for production environment and machine critical databases.
• Experience in developing data migration strategies.
• Effectively used V-Blocks to restore data.
• 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/2008 R2, and 2012.

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, 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.

PROFESSIONAL EXPERIENCES

Confidential, Orlando, FL

Technical Lead

Tools: & TechniquesSQL 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.

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 & Resrots critical systems.
• Managed 3000 servers from different poles.
• Managed database instances, monitor server performance, fine tune database server and applications, and perform backup and recovery by using SQL Native.
• 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 & HP OVO monitoring
• Experienced in query optimization, index tuning, performance tuning
• Utilized OSQL script for Automatic backup report for Production databases
• Installed SQL Server 2005, 2008, 2008 R2 and 2012 versions on MS Clusters.
• Applied SQL patches on MS Cluster SQL Instances and Mirrored databases
• Database refreshing to development environments.
• Configured Database Mirroring & Log shipping for DR & reporting purpose
• Established Transactional replication between Orlando to China Databases
• Configured SPN’s for service accounts for Production database instances
• Implemented Minimum Security Base lines on PCI & PII data base instances
• Implemented AlwaysOn for WDPR segment servers.
• Upgraded SQL server license on CAL based system.
• Restored databases on critical systems by using V-Block technologies.

Confidential, Anaheim, CA

Senior Technical Specialist

Tools: & TechniquesSQL 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.

Responsibilities:

• Administered File service management service large databases.
• Implemented Mirroring for Walt Disney critical systems.
• Supported 1500 servers from different geo’s and configured Mirroring and Transactional Replication as part of Disaster recovery procedure.
• Extensively worked with Microsoft team on Microsoft Cases for Critical situations as per Client requirement.
• HP Open View is used for Data base monitoring and alerting system.
• 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.
• 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.
• Used Double Take for disk level mirroring in Disney Media segment.

Confidential, Milwaukee, WI

Technical associate

Tools: & TechniquesSQL 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.
• 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.
• 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
• Data base refreshing to development environments.
• Migrated machine critical databases in less span of down time using database Mirroring.
• Fixed or resolved several levels of tickets Sev 1, Sev 2, Sev 3 & Sev 4.
• Developed Stored Procedures, views and full text indexes.
• Fine-tuned database queries with the help of Database Tuning Advisor ( DTA)

Confidential, Fairfield, CT

Technical Specialist

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

Responsibilities:

• 24/7 On-Call Production support
• Administered Max size of database for GE Oil & Gas.
• Implemented Log shipping & mirroring for critical systems by considering risk management disaster recovery plan.
• Configured Transactional Replication between different data centers and business segments
• Managed 1500 servers from different poles.
• 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 and Request Managements.
• Configured Linked servers & Network aliases.
• Created logins and maintained user permissions appropriately and implemented Microsoft Security Best practices tightly aligning with Security controls.
• Implemented Minimal Security Base line controls 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.
• Fixed or resolved several levels of tickets Priority 1, Priority 2, Priority 3 & Priority 4.
• Developed Stored Procedures, views and Cursors as per business requirements.
• Prepared RCA for Priority 1 & Priority 2 tickets on database outages.
• Reviewed SQL performance and Tuning
• Fine-tuned database queries with the help of Database Tuning Advisor ( DTA)

Confidential, Sacramento, CA

Technical Specialist

Tools: & TechniquesSQL Profiler, SQL Query Analyzer, DTA, DTS (Data transformation Service) tools, OSQL, CMS (Central Management Service), Replication server, SQL Agents, SQL Alerts, SQL Jobs, T-SQL, SQL Diagnostic manager ( SQL DM), BMC remedy, SSIS and SSRS.

Responsibilities:

• 24/7 On-Call Production support
• Administrate 900GB of database for WOWZZY
• Implemented Mirroring for WOWZZY
• 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
• Configured search mechanism by using Full text Catalogs
• Optimized Performance of SQL Queries by using DTA tool
• Perform day to day Database Maintenance tasks, Backups, Space Management, Rebuild Statistics for all production database Servers.
• 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, CA.

SQL Team Member

Tools: & TechniquesSQL Profiler, SQL Query Analyser, DTS, Replication server, DMV’s, SQL Agents, SQL Alerts & notifications, SQL Jobs, T-SQL, BMC remedy.

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.
• 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

Tools: & TechniquesSQL Profiler, SQL Query Analyser, DTS (Data transformation Service) tools, Replication server, SQL Agents, SQL Alerts, SQL Jobs, T-SQL, BMC remedy, HP Support Central

Responsibilities:

• Created logins, database users and assigning roles
• Managed 20 servers
• Configured Replication between different sites
• Configured mirroring for Realtor Reality Managements
• Plan and implement backup, recovery strategy.
• Creating and maintaining 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
• Written stored procedures and cursors as per business logic

Confidential

SQL Team Member

Tools: & TechniquesSQL Profiler, SQL Query Analyser, DTS (Data transformation Service) tools, CMS ( Central Management Service), Replication server, SQL Agents, SQL Alerts, SQL Jobs, T-SQL, BMC remedy and SSRS.

Responsibilities:

• Administered 400GB of databases for ClassPedia
• Involved in Performance Tuning by using DTA tool
• Configured Database Mirroring between two poles.
• Installed MS SQL Server 2005
• Created regular backups of databases and transaction logs using SQL Safe- IDERA.
• Configured database monitoring under SQL Diagnostic Manager ( SQL DM)
• Perform periodic checking of databases with DBCC command for maintaining data consistency and integrity and rebuilt indexes.
• Pulled out reports by using SSRS