PROFESSIONAL SUMMARY:

• Around 7 years of total IT experience in administering databases on both MSSQL Server versions 2005/2008R2/2008/2012 and MySQL server versions 5.0/5.1/5.2/5.4/5.6/6.0.
• Experience in configuring SQL Server Instances in clustering and enabling SAN level replication to ensure Always on feature.
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).
• As new systems are brought in - house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies.
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
• Troubleshooting hardware using tools like Dell Open Manage, HP System Insight Manager, and IBM Director.
• Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.
• Maintain data integrity and security (manage roles and permissions of database users).
• Create detailed documentation including diagrams of database infrastructure.
• Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
• Knowledge of other databases like MySQL, No SQL databases and In-memory databases.
• Analyze about Server operations and resource consumption using SQL Server DMV and providing suggestions to application/development teams for optimal server performance.
• Troubleshooting SSIS package using SQL agent job and providing root causes/recommendations to app teams and ensure corrective actions are followed/maintained.
• Experience in installing and configuring MS SQL Server versions 2012/2008R2/2008/2005
• Experience in installing and configuring MySQL Server Versions 5.0/5.1/5.2/5.4/6.0 on both Windows and Linux Servers.
• Creation of Databases and configuring backup/restore operations.
• Implemented Disaster Recovery mechanisms/scenarios for critical financial applications to make sure always database availability in real disaster.
• Worked on Always availability feature in SQL Server 2012 and configured Always availability groups for critical production databases.
• Gathering the requirements from application support teams, Document and implement the database design.
• Coordinating with various support teams like Network, Storage and Windows Admins for managing databases administration and smooth running of applications.
• Assisted application development teams on infrastructure capacity planning and system design
• Adding/virtualizing SQL Instance to active-passive failover Veritas cluster as per client requirement along with SAN storage implementation.
• Experience in ITSM process like Change, Problem, request and incident management for all SOX critical financial and healthcare applications.
• Migration of Databases as per application requirements to accommodate additional security features and high availability options like Disaster recovery procedure to ensure Always availability for application.
• Upgrade of SQL Instances 2005 and and installing service packs as part of SQL Server patching and migration activity.
• Trouble shooting issues with clustering and coordinate with Windows and network team to fix them on time.
• Adding or Removing nodes to existing Clustering for SQL Server instances in Prod/QA environment.
• Configured Mirroring/Log shipping/Replication for critical application databases.
• Experience in Performance Tuning, client/server connectivity and database consistency checks using DBCC utilities.
• Worked on SQL Profiler, Windows Perfmon and Performance counters for Monitoring and Tuning MS SQL Server Performance issues.
• Identify and resolve locks / long running queries and performance related issues.
• Worked in 24/7 on-call support model to support critical applications and minimize downtime
• Experience in upgrading MS SQL Server and SQL Server and SQL Server 2008R2 to SQL Server 2012.
• Experience in configuring transactional Replication from multiple subscribers for reporting purpose
• Setup Alternative production environment for all production environments and switch over to it during disaster and ensure always databases availability for critical applications.
• Configured MySQL Server replication for critical application databases and enabled access for app support teams on replicated databases for active reports generation.
• Administration of MySQL databases using Workbench and monitoring/managing database backups as per application requirement.
• Migration of databases from SQL to MySQL and Oracle using data migration wizards as per application requirement.
• Server automation and Manual Testing.
• Customization of application scripts.
• Creating database schemas and application tuning under production environment and Setting up IEP (inbound email processor) which involves from/reply to/return path email address creation, Communication with ISP if any of the IP-address is been blocked to know the reasons for the same.
• Installation of MySQL server and configure high availability scenario (Replication) for critical applications and document database design.
• Analyzing and reviewing long running queries through SQL snippet code panel from MySQL Workbench and fine tune Query with Index adjustments.
• Develop and support MySQL database replication.
• Optimize MySQL database performance.
• Estimate MySQL database capacities; develop methods for monitoring

  database capacity and usage.

• Establish mechanisms for data backup/restore of relational databases;

  provide restoration services as needed.

• Develop and optimize physical design of MySQL database systems.
• Develop application-specific fault-tolerant distributed database

  mechanisms.

• Provision MySQL instances, both in clustered and non-clustered configurations
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary
• Proficiency in MySQL database management.
• Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
• Knowledge of best practices in MySQL and standards.
• Proficient in writing and optimizing SQL statements
• Knowledge of MySQL features, such as its event scheduler
• Ability to plan resource requirements from high level specifications
• Familiarity with other SQL/NoSQL databases.
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
• Proficient understanding of code versioning tools such as(Git / Mercurial / SVN).
• Performs database health monitoring across all database systems.
• Works with the development teams to facilitate proper schema design, creation of appropriate indexes, and properly optimized queries.
• Works with the development teams to introduce and control structural changes to databases with minimal disturbance to production.
• Sets and manages user privileges within the database environment.
• Provide ongoing support for Data Warehousing ETL and Data Analytics activities.

TECHNICAL SKILLS:

Database: SQL Server 2012/2008/2008 R2/2005, SQL Trace, SQL Server Profiler, Database migration tools, Database Engine Tuning Advisor, SQL Server Configuration Manager, Database Mirroring, Log Shipping, Replication, Clustering, SQL Server Always On feature, Veritas Cluster Console, HP polyserve Cluster manager, Microsoft Cluster 2008/2008R2/2012, Shell Scripting, pearl scripting, Power shell scriptingOperating Systems Windows 2012/2008R 2/2008/2003/2000, Red Hat Linux 5.0, Solaris 10.0

Tools: and Utilities VMware, Toad, SQLDM, SQL Safe, SQL Secure, SQL compliance, OEM 12c Grid Control, Big Brother, MySQL Server Workbench, BMC Patrol, Team Foundation Server (TFS), Visual Source Safe (VSS), Remedy, Service-Now, ITSM, MySQL Server Workbench, MySQL Server Migration tools, Password Safe, Cyber-Ark, HP QC, Cygwin, SQL Server Visual Studio. Virtualizing SQL Instances to get balanced in cluster configuration for high availability implementation of Critical application databases.

PROFESSIONAL EXPERIENCE:

Confidential, Stamford, CT

Lead Database Administrator

Responsibilities:

• Created ETL SSIS packages both design and code to process data to target databases.
• Enabling database trace to resolve performance issues for application and fine tune queries based upon real time business scenario.
• Analyze current structure and make appropriate changes as defined by our MySQL standards.
• Installation and configuration of MySQL server versions 5.0/5.1/5.2/6.0.
• Monitoring and managing MySQL Databases through MySQL Workbench.
• Configuring MySQL databases through pearl scripting.
• Work closely with Business Analysts, Product Managers and developers to design and define.
• Convert data from existing MySQL to a new instance of MySQL.
• Produce SQL scripts for both one time and recurring conversion for MySQL hosted Instances.
• Produce shell scripts to process the recurring data conversion as needed in Linux servers to support MySQL Server release activities for smooth flow of production activities.
• Monitoring of MySQL database system utilization and query performance, working closely with development teams to provide the highest level of database performance
• Ensuring replication integrity and consistency amongst database cluster members for MySQL Servers
• Maintaining and improving security of data access through proper database system architecture, policies and procedures
• Management of MySQL database server/engine configuration and tuning
• Troubleshoot database, systems, and applications to identify and correct malfunctions and other operational problems.
• Created ETL packages in SSIS with different transformations (Data Conversation, Lookup, and Aggregate).Performed day to day Database Maintenance tasks, Backups, Space Management, Rebuild Statistics for all production database Servers and configured agent alerts when job fails.
• Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
• Developed SSIS Packages to process Oil and Gas stores purchase data from different sources (Flat file, raw file) to different destinations.
• Administered Max size of database for Confidential applications.
• 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 DELL tool, SQL Lite speed.
• 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 financial data bases instances.
• Database refreshing to development environments.
• Migrated databases from one version to another version and applied security patches as per vulnerability.
• 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.
• Installed SQL Server instances on different windows boxes using Split stream installation.
• Worked on Database Maintenance, Backups and Recovery Plans.
• Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio.
• Monitor SQL Error Logs/ Schedule tasks/data activity/ eliminate blocking and deadlocks/ user counts and connections/ locks and 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 linked servers between SQL Server databases to DB2 destination.
• Implemented Log shipping/ Mirroring for report purpose and as well DR setup.
• Configuring SQL Server in VERITAS cluster and adding new SAN mount points to existing failover clustering architecture.
• Coordinating with NT Team and perform database health check post OS patching activity. Implemented batch scripts for automating these tasks.
• Analyzing database growth analysis and documenting in database design specification document. Coordinating with network and application teams for implementation.
• Upgrading SQL Server Service packs for SQL Instances to overcome security vulnerabilities for SOX critical applications to maintain compliance standards.

Confidential

DBA - Senior Database Administrator

Responsibilities:

• Involved in designing the procedure for data migration
• Developed shell scripts for automating data migration
• Developed test scenarios and test procedures based on the requirements.
• Created IQ/OQ test Cases and assign to test lab lead to validate after successful execution of tests.
• Performed database testing on migrated data along with migration of Logins/jobs/stored procedures.
• Create and maintain Active/Deactivate dates of SQL Instances and update SQL Instances in alert mechanism of Monitoring tools by setting threshold values accordingly.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems as well as managed the subscription of the reports.
• Created SSRS reports like drill down, drill through and sub reports.
• Developing SSRS Reports like Sub Reports, Linked Reports and Graphs.
• Gathered requirements to build SSRS reports as per business.
• Subscribed reports from SSRS Report Builder.
• Experienced reports using cascading parameters, Parameterized reports, report models for Adhoc reports using SQL server Reporting services (SSRS) based on requirements.
• Was always available for production support (24/7 On-Call).
• Installation of MySQL Servers and configuring Replication (master-salve) multiple servers.
• Configuring Backups MySQL Databases for critical production applications as per application specifications defined in run books.
• Configuring Disaster recovery scenarios for critical health care MySQL databases through high availability options like replication and clustering.
• Migration of MySQL Databases to SQL & Oracle during application upgrade process using MySQL Server migration wizard.
• Worked on optimizing the MySQL Server performance through Re-org/Rebuild operation on scheduled basis.
• Working with various teams like Network and application support and deploy scheduled changes/releases and regular maintenance activities.
• Upgrading MySQL Servers to latest available builds.
• Played a key role in database (DB Size 3.5 TB) administration for managed solutions application hosted in third party hosting technologies.
• Implemented Mirroring and Replication for Healthcare 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.
• Managed VCenter Databases and fixed issues on database level.
• Performed day to day Database Maintenance tasks, Backups, Space Management, Rebuild Statistics for all production database Servers and developed script for backup automation in Power Shell 3.1.
• Installed and Configured SQL Server 2005, 2008, 2008 R2, 2012 and 2014 versions on MS Clusters.
• Experience in Agile (Scrum) SDLC methodologies.
• Applied SQL patches on MS Cluster SQL Instances and Mirrored databases.
• Installation/Up gradation of Database and Client Software Configured Database Mirroring & Log shipping for DR & reporting purpose.
• Developed Web Application for internal purpose in ASP.Net, HTML, CSS and C#.Net, hosted in IIS.
• Document database environment and kept in document share point repository.
• 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.
• Developed Stored Procedures, views and full text indexes and fine-tuned database queries with the help of Database Tuning Advisor (DTA).
• Virtualizing SQL Instances in HP polyserve clustering software and make sure automatic failover happen for critical application during disaster/server issues.
• Troubleshooting issues with HP polyserve clustering and SQL instances hosted in it.
• Migration of the SQL Servers and databases from HP Polyserve to Windows clustering 2008 R2.
• Installation of SQL Server through Command line utility and perform serial installations in multiple nodes through multimode installer in Polyserver cluster environment critical healthcare applications.
• Migration of SQL Server backups to a Centralized SAN where storage level replication implemented to various geographical locations from individual server backups path.

Confidential

SQL Server DBA / Technical Analyst

Responsibilities:

• As part of Live Nation Global Trading System Technical team, provided technical support for Chevron’s highly critical Trading applications and its databases.
• Installation and configuration of MySQL database Servers versions 5.0/5.1/5.2 and 6.0.
• Manage MySQL Databases through Workbench. Monitoring and auditing databases through it.
• Installation and Configuration of SQL Server 2005/2008/2008 R2.
• Created Instances and databases for various Production and non-Production environment with size ranging from 500 GB to 3 TB.
• Installed and configured SQL Server 2008 in production and non-production environments
• Designed and implemented comprehensive Database Backup & Recovery Strategy.
• Involved in designing the procedure for data migration.
• Developed shell scripts for automating data migration
• Developed test scenarios and test procedures based on the requirements.
• Created Test Cases based on Functional Specification.
• Performed database testing on migrated data.
• Setting up MySQL replication for production databases hosting critical application.
• Create and maintain Test Summary records, Test Log and, analyze defect data.
• Manage database security and review access periodically
• Successfully implemented Database Mirroring in SQL Server 2005 and 2008 for High Availability.
• Worked on adhoc database backup (Native and Lite speed) and refresh requests for non-production environments
• Configured transactional replication between OLTP server and report server
• Creating and maintaining database maintenance plans.
• Assist with sending operational data between sites during disaster scenarios
• Detach and Attach databases, manage and modify database files
• Deploying database objects to development/testing environments
• Extracted data from disparate sources and loaded into staging database and data warehouse performing extensive ETL operation.
• Worked on database Performance monitoring and tuning.
• Modified multiple DTS packages for migration
• Use custom scripts so as to help automate routine tasks.
• Created operators, Alerts, Notifications
• Created SQL Jobs, Database Maintenance plans Schedule for execution at specified time
• Proactive monitoring for 24*7 servers
• Implement and Monitor SQL Server log shipping and support and perform proactive steps.
• Documented the database configurations, database objects, job schedules and maintenance plans
• Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Worked on query optimization, database optimization and index tuning
• Manage database maintenance including integrity checks, re-indexing, reorganizing
• Design, Deploy and administer various critical Trading applications (SolarcRightAngle, ICTS, GARM etc.)
• Provide Level 2 support on configure and troubleshoot published applications on Citrix servers
• Manage Software version control using Team Foundation Server
• Document process for managing database structure rollouts and assist with software releases
• Followed ITIL based process on Incidents, Changes and Releases.