We provide IT Staff Augmentation Services!

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

We'd love your feedback!