PROFESSIONAL SUMMARY:

• 5 years of experience in Database Management Technology in cluster, replications and log shipping
• Extensive experience in database design, implementation and administration in MS SQL Server 2012/2008/2005/ 2000/7.0/6.5, Data Warehouse, SSIS, SSRS
• Strong SQL Back End Programming in both Web based and Client/Server environment
• Experience in Oracle 11g RDBMS, Reports 2.5, MySQL, DynamoDB, Amazon RDS, AWS Cloud Watch
• Experience in Cloud Strategies based on AWS.
• Excellent communication skills and a key team player. Highly motivated and quick learner

TECHNICAL SKILLS:

Languages: SQL, T - SQL, PL/SQL, HTML, CL and Shell Script, Web Service JSON pattern

Software: Oracle Developer/2000, Forms, Reports, SQL*Plus, SQL*Loader, Crystal Report 6.0/7.0/8.5/9.0, MS Central Microsoft SQL Server Management Studio, SQL Server Data Tools, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio and MS Visio.

Database: SQL Server 2014/2012/2008/20005/2000 Oracle 11G, MySQL, OLTP, DTS/SSIS, OLAP, Data WarehouseBusiness Intelligence, MS Reporting Services, MS Analysis Services, SSIS, SSRS, BCP

Systems: Windows 7,8/XP/NT/2000/98/95, UNIX, Linux.

AWS: Automated Build Tools, Cloud Technologies, CI/CD Tools, Configuration, Management, Version Control Systems

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

• Provide Production Support for MS SQL Server Databases in High Availabilities
• Perform day - to-day administration on SQL Server 2005-2012 environments
• Set up and Configure database Mirroring, Log shipping, Replication
• Ensure database health and integrity across all systems
• Diagnose & troubleshoot issues, Conduct performance tuning for optimizations
• Manage database Capacity growth and refresh data from production to lower environment
• Monitor databases, migrate SQL Server from SQL 2005 to SQL 2008
• Support SSIS, SSRS, Data warehousing\Manage and implement production release
• Lead the Disaster Recovery
• Install SQL Server in Cluster and Migrate SQL Server from SQL 2008 to SQL 2012
• Set up and configure database Mirroring, Log shipping, support SSRS, SSIS
• Automate maintenance jobs, install services patching
• Identify problems, find root cause and perform tuning to ensure application performance
• Manage database Capacity growth, write stored procedures, triggers
• Maintain & manage Database security, install monitor tools on the Server
• Experience setting up transparent data encryption (TDE) user security in Oracle and backup database

Confidential

SQL Server DBA

Responsibilities:

• Provided production support for MS SQL Server 2005/2008 and maintenance in High Availability Cluster, Logshipping, Mirroring and SRDF
• Collect business need to design server specs for new projects, install & configure new SQL Server 2008 in Cluster
• Conducted SQL Migrations from SQL 2000 to SQL 2005 and to SQL 2008 for large Data Center
• Set up database Log shipping, Mirroring, Replication, install & configure monitor on the Server
• Diagnosed bottlenecks, Perform tuning for optimization
• Managed database capacity growth, support Business Intelligence, MS Report Services
• Implement service packs and manage database health, manage user security for compliance
• Set up maintenance jobs and configurations on the Server
• Provide support for production releases related with database work
• Install SQL SERVER 2008 On Cluster
• Migration Databases from SQL 2005 to SQL 2008
• Manage and maintain 2008/2005 Production Database Servers, SSIS, SSRS
• Support Developers and Business, write stored procedures\Queries
• Set Best Practice for the server management
• Conduct Performance tuning and work with Full text Index

Confidential

SQL Server DBA

Responsibilities:

• Manage and Support MS SQL Server 2000/2005 Production Databases
• Install SQL Server in Cluster and upgrade SQL Server from SQL 2000 to SQL 2005
• Troubleshoot and Conduct performance tuning for applications
• Automate DBA activities to help ensure the high availability of the Server
• Write stored procedures, triggers and views
• Set up log shipping and management strategy and Capacity planning
• Configure database in SQL 2005 to automate operation alert
• Maintain and support developers for SSIS/DTS, SQL Analysis Services SSRS
• Migrate DTS to SSIS and Implement SSIS to load data into DW systems
• Support large web applications and large Data warehouse systems
• Manage and Support large amount of MS SQL Server 2005/2008 database in high availability environments including Cluster and Log shipping, Replication
• Lead DBA for consolidating MS SQL Server databases on HP Polyserve Matrix
• Proactively monitor, tune and improve Database Performance
• Strong ability to Identify/ troubleshoot problems and resolve real-time database issues
• Conduct performance tuning for applications
• Perform database Backup and Recovery, lead the Disaster Recovery
• Upgrade MS SQL Server 7.0/6.5 to SQL 2000 and from SQL 2000 to SQL 2005
• Write batch files to Manage databases and Migrate data across Servers
• Transfer data from different platforms using DTS/SSIS package
• Design and troubleshoot DTS packages for the business needs
• Write stored procedures, triggers and views
• Create database and Manage backup in SSMS/MSSQL
• Automate DBA activities to help ensure the high availability of the Server
• Apply SQL Service patches and manage SQL server security, Support SharePoint in SQL
• Support SSAS and Manage OLAP database for Data warehouse for financial business
• Setup log shipping and replication
• Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
• Built database Triggers and Referential Integrity Constraints to implement business rules