SUMMARY:

• Bachelors in BA Management with 6 plus years SQL Server DBA experience
• Professional experience with SQL server 2016/2014/2012/2008/2005/2000 Database server installation, TSQL, Backup/Restore, Troubleshooting and Performance tuning on 24/ 7 systems
• Professional experience of high available technology, like AlwaysOn, Cluster, Mirroring, Replication and Log Shipping.
• SQL Server installation and configuration for application specific requirement.
• Performance tuning with Idera, fog light and SQL and system monitoring with MOM and SCOM
• Database migration from legacy application with upgrade, using data transfer tools
• Used DMVs, triggers and system procedures for troubleshooting.
• Extensive performance tuning experience, specializing in instance tuning and SQL optimization.
• Extensive experience with designing and implementing SQL Server databases, including systems and database architecture, project management, implementation and tuning.
• Experience working with Windows NT/ 2000/2003/2008 R2/2012R2/2016
• Strong team player with great verbal, written communication and interpersonal skills
• Ability to prioritize and complete multiple tasks and detail oriented
• Proven capability to approach problems effectively and creatively in complex environment
• Quick learner, take initiative, and hard worker

PROFESSIONAL EXPERIENCE:

Confidential

CONSULTANT SQL SERVER DBA

• Handled Administration of SQL Server 2005, SQL 2008R2, SQL 2012 and SQL 2014 providing production support for over 800 enterprise instances.
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 4 Node
• Worked extensively in automating process like creating jobs, and error reporting using Alerts, SQL Mail Agent
• Developed and implemented comprehensive Backup plan and disaster recovery strategies
• Managed a centralized MS SQL Server 2008 and 2012 Platform consisting of over 500 mission critical databases
• Resolving requests related to database and system issues raised by user support
• Created and maintained windows domain with 500 number of clients which is spread across multiple locations
• Planned and executed many upgrade such as Service Pack, Hot fixes etc.
• Handled Fine Tuning Databases System in - coordination with Application owners to utilize the maximum resources for Database and Applications.
• Upgrade of Database from SQL Server 2005 and 2008R2 to SQL 2012and 2014.
• Migrated up to 250 servers and over 600 databases from a legacy Datacenter with upgrade to new Datacenter.
• Installed & configured database with associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Estimated disk storage requirements for database software, database files & database administration needs.
• Provided optimal database file layout for utilization of storage and performance acceptable to client.
• Configured and manage SQL Server 2012 Always-On solution with 4 replicas.
• Participated in meetings impacting databases physical design.
• Customized support for Client’s Applications (e.g. Third party supported/In-House Applications etc.) provided client will own the responsibility of creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.).
• Provided appropriate access to client except system databases owners’ and Client will have access to their respective needed application schema owners.
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Developed, tested & implemented a robust database backup and recovery strategy in line with client disaster recovery RTO and RPO objective.
• Implemented requested refreshes pre or post restore activities (e.g. data loads).
• Database recoveries as per requirements.
• Conducted root cause and analysis for database incidents and problems.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
• Suggested application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
• Adhered to Change Control Procedures and worked with Change and Incidents management tools

Confidential, Dallas TX

SQL SERVER DBA

• Developed & executed scripted changes requests in accordance with change control procedures.
• Upgrade of Database from SQL Server 2000, 2005 and 2008R2 to SQL 2012.
• Provided overall configuration and change control management for data base components.
• Escalated database issues to appropriate approvers (if applicable).
• Conducted research and collaborated with vendor if necessary for additional patches.
• Provided stopgap solutions if possible and acceptable by business and application team owners.
• Researched, reviewed and recommended for preventive maintenance.
• Set up security and access profiles and procedures for database system administrators.
• Complied with standard security-related procedures that are based on established best practices and conformity to company policy and adjusted to accommodate Client Security Policy based on mutual agreement.
• Interfaced with database vendors & client technical support teams to isolate & resolve database related problems.
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 6 Node.
• Handled Logical Data and Index partitioning for large tables in SQL Server 2005 and 2008R2.
• Provided & managed support to Environment of more than 800 Database Servers.
• Proven ability to handle database of more than 1 TB in Size.
• Expertise in MSSQL SERVER Database Administration.
• Configured and managed multi transactional replication chain on a production database.
• Set up Log Shipping, MSSQL Mail, SMTP
• Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, DA, User etc and ensured the Availability of the Database Server in a 24X7 Environment.
• Scanned the data pages, Indexes and checked the storage space used by each table.
• Suggested, developed & implemented Scaling out solution with Data partitioning.
• Managed security by defining roles and rights.
• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
• Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures.
• Monitored and modified Performance using execution plans and Index tuning
• Proactive and active performance monitoring and tuning of production databases
• Worked with application development and support teams to resolve database service requests and incidents within agreed upon SLAs
• Participated in implementation of new releases into production
• Provided on call support as needed to support operations of critical databases in a 24 X 7 environment