Consultant Sql Server Dba Resume
4.00/5 (Submit Your Rating)
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