We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

4.00/5 (Submit Your Rating)

Southlake, TX

SUMMARY

  • Over 9 years of experience in IT in Database Administration and Developer for very large and complex databases in SQL Server 2012, 2008 R2, 2008, 2005 and 2000.
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Worked on SQL Server 2008R2 Migration from SQL Server .
  • Administering SQL Server High Availability and Disaster Recovery strategies.
  • Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
  • Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
  • Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
  • Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
  • Having hands on experience in DR processes including AlwaysOn, Log shipping and Database Mirroring.
  • Troubleshoot performance problems, fine - tuning of databases and index Analysis.
  • Experience in using DMV and dynamic management functions for finding out long running queries.
  • Worked on configuring SQL Server with minimum privileged access.
  • Handled multiple SQL Instances on Cluster environments for Server Consolidation projects built on SAN using RAID levels.
  • Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
  • Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
  • Having Experience on Data center servers and handling 22 TB databases.
  • Experience in using tools like SQL Sentry, SQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance.
  • Working knowledge in data transformation services like SSIS, DTS, BCP and Bulk Insert.
  • Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
  • Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
  • Working knowledge in Analysis Services (SSAS) and Reporting Services (SSRS).
  • Implemented different types of Replication models like Transactional and Snapshot
  • Strong experience in mentoring team members and writing documentation.
  • 24 X 7 Production Database on Call Support
  • Worked on importing data from MySQL to SQL Server.
  • Expertise in T-SQL writing stored procedures, triggers and functions.
  • Worked on logical and physical data base modeling with UML and ERWIN tools
  • Worked on Sales Force, Jira, BMC Remedy, Resolve, Virtual Ticket & Service Now ticketing system software’s.

TECHNICAL SKILLS

Databases: MS SQL Server 2014, 2012, 2008, MS SQL Server 2005, 2000

Programming: Visual Basic 6, Visual Basic 5, C, C++ & SQL

DBA: database administration of SQL Server 2012, 2008R2, 2008, 2005, 2000

Operating System: Windows 2008/2003/2000 Advanced Server, NT & Windows 9x, Linux

Tools: SQL Sentry, Backup Utility, SQL LiteSpeed, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Southlake, TX

Sr. SQL Server DBA

Responsibilities:

  • Analyzing the Database Infrastructure / servers / storage and provide technical recommendations for improving the SLA times with business users and implement optimization changes for better performance for applications.
  • Migrated SQL2008 applications to SQL2014 with Always on high availability clusters for disaster recovery and reporting.
  • Implementation of Replication Models (for OLTP Servers) using Merge and Transactional (with updatable subscriber) on large terabyte databases.
  • Involved in Fine Tuning and Performance and Query optimization of the Database as required by the application.
  • Successfully restored 22 TB database having thousands of data files and shrink back to 6 TB of size.
  • Implemented 2 way Replication (Pub-Pub) between 1 Publisher and 3 Subscribers.
  • Worked closely with Storage groups to find out the underlying Disk I/O sub system issues with SAN.
  • Implementing the Security strategy for each environment and the required backup strategy as well.
  • Use DMVs and custom scripts to tune performance of SQL Server queries.
  • Provided support for SQL Server Reporting Services (SSRS) including installation, configuration, report deployment, setting up report subscriptions and managing security.
  • 24 X 7 On-call support rotation for SQL Server database systems, products and services.
  • Work with Microsoft PSS Support to troubleshoot and debug SQL Server / Windows problems.
  • Develop and deploy trace files to audit DBA activities, DDL commands and Security events in SQL Server. Automate the process of reporting unauthorized activities.
  • Design and develop database backup and recovery procedures.

Environment: MS SQL Server 2014/2012/2008 R2/2008, SQL Lite Speed, SQL Sentry, Visual Studio 2010/2005 and Windows Server 2008/2003, SSRS, SSIS, BCP and Microsoft Cluster.

Confidential, Irving, TX

Sr. SQL Server DBA

Responsibilities:

  • Installed/Configured and upgraded PROD/COB/UAT/DEV environments from SQL Server 2005/2008 R2 to 2012.
  • Deploy High Availability and Disaster Recover solutions like AlwaysOn, Database Mirroring and Log Shipping to provide multiple copies of production data that can be used for disaster recoveries.
  • Set up Log shipping between Primary Server (PROD) & Secondary Server (COB).
  • Worked on Cob tests during weekends to test COB environment by business users.
  • Work closely with infrastructure and security teams in evaluation of hotfixes/security patches and make sure all environments are up-to-date.
  • Worked closely with Microsoft to make sure the recurring corruption issues are fixed in our Database environment
  • Extensively worked on auditing entire environment by building SQLMonitoring database to capture everything single thing in the prod environment.
  • Deploying new code base release to UAT and Production Environments.
  • Successfully implemented a project to set up process of automated log shipping without primary server by just using backups.
  • Provide expertise for using best RAID Technologies based on application requirement.
  • Use DTA (Database Tuning Advisor), to identify indexes that can help improve performance.
  • Extensively used Service Now tool for any changes in the environment and also incidents.
  • Provided 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
  • Conducted root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks or network latency.
  • Used SSIS to move auditing files from SQL server to Unix server.

Environment: MS SQL Server 2012/2008R2/2008/2005, SQL Lite Speed, RedGate SQL Compare, Visual Studio 2010/2005 and Windows Server 2008/2003.

Confidential, Plano, TX

SQL Server DBA

Responsibilities:

  • Installed, Configured and Administered SQL Server 2012/2008R2/2008 Servers in Production, QA, Pre-Prod and Dev environments.
  • Responsible for overall database environment and maintain operational uptime of 99.9%.
  • Performance tuning, capacity planning, trend analysis, and server sizing for very large databases.
  • Installed and managed multiple 3 node failover cluster set up in active/active clustered environment as a High Availability mechanism.
  • Designing, Implementing and administering the transactional replication from Primary database server to the 6 search pool servers.
  • Setup SQL Mail and integrate it with the application, design and manage replication.
  • Install and configure SQL LiteSpeed for SQL Server to backup SQL Server database or setup database maintenance plan to back up all the databases locally on the disk.
  • Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
  • Implemented Transactional Replication for different applications and managed replication and database modifications for replicated objects
  • Monitoring the servers usingIdera third party software and backups using SQL Litespeed.
  • Ticketing systems like Resolve for Change Request, Sales Force, BMC Remedy etc.,
  • Deployed SSIS packages and worked on Reporting services.
  • Created logins and Roles with appropriate permissions for temporary and permanent access requests.
  • Scheduling the Backups and performing the restoration. Support for huge Databases.
  • Provided 24/7 on-call support on rotation basis for production database.

Environment: MS SQL Server 2012/2008R2/2008/2005, Idera Diagnostic, SQL Lite Speed, RedGate SQL Compare, Visual Studio 2010/2005 and Windows Server 2008/2003.

Confidential, Irving, TX

SQL Server DBA

Responsibilities:

  • Upgraded SQL Server R2 and SQL Server in Microsoft Windows Server 2008 R2 Enterprise Edition.
  • Successfully implemented Database Mirroring in SQL Server 2005 and 2008 for High Availability.
  • Performed Backups and restores on regular basis for Migration and other purposes.
  • Migrated SSIS packages from SQL Server 2005 to SSIS 2008.
  • Use custom developed scripts to identify missing indexes.
  • Worked with tickets like RFC’s for prod/UAT changes and VT’s for QA/DEV servers.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Designed and implemented comprehensive Backup plan using SQL LiteSpeed.
  • Used SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
  • Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and indexing updates.
  • Database refreshes from prod to stage, test and development environments.
  • Tested and Implemented procedures to detect poor database performance, collecting required information and root cause analysis.
  • Production and on call support on rotation basis.
  • Solved issues related to server performance and disk space.
  • Rebuilding the indexes at regular intervals for better performance.

Environment: MS SQL Server 2008R 2/2008/2005/2000 , Visual Studio 2010/2005, SQL Lite Speed, Microsoft Visio 2003, SFTP and Windows Server 2003/2000.

Confidential, Coppell, TX

SQL Server DBA

Responsibilities:

  • Installed and configured SQL Server 2005 and 2008R2 in production and development environment.
  • Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2008 Enterprise Edition on SAN environment
  • Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005/2008.
  • Provided 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
  • Expertise in designing databases and capacity planning.
  • Created jobs, alerts, activity logs, error logs to capture any possible errors.
  • Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Transferring the data (ETL) to Data ware house by SQL Server 2005 Integration Services.
  • Implemented log shipping in SQL Server 2005 from primary server to standby server to support DR solution.
  • Creating documentation for error resolving fixtures.
  • Worked with Jira ticketing system software to solve issues.

Environment: Microsoft Windows Server 20 /64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft SQL Server 2008 and SQL Lite speed.

Confidential, Dayton, OH

SQL Server DBA

Responsibilities:

  • Installed SQL Server 2005 and apply service packs, hot fix and clustering installation.
  • Database Administrator, Database Programming.
  • Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Configured transactional Replication from multiple subscribers for reporting purpose.
  • Deploying new code base release to UAT and Production Environments.
  • Working with customers on Application rollouts and server migrations.
  • Extensively worked on DBCC commands and Dynamic Management Objects.
  • Worked with change management and change control procedure.
  • Converting DTS packages into SQL Server 2005 Integration Services
  • Solved issues related to server performance and disk space.
  • To analyze long running slow queries and tune the same to optimize application and system performance.
  • Support Development team in deploying and testing the application.

Environment: Microsoft Windows Server 2000/ /64 bit, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft Visual Studio 2005.

Confidential

SQL Server DBA/Developer

Responsibilities:

  • Perform business analysis, technical analysis, systems design, application software programming.
  • Involved in Optimization and Performance Tuning of SQL Server using SQL Profiler and Performance monitor.
  • Create Database Objects like Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
  • Managing the use of disk space, memory and connections. Running DBCC consistency checks, and fixing data corruption in application databases .
  • Rebuilding the indexes at regular intervals for better performance.
  • Manage replication and database modifications for replicated objects.
  • Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
  • Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
  • Design, document and implement SSIS packages and stored procedures.
  • Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Support and troubleshoot as required, optimize performance and resolve production problems.
  • Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
  • Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.

Environment: Windows 2003 Server, SQL server 2005/2000, Event Viewer, SQL Profiler, T-SQL.

We'd love your feedback!