We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Asheville, NC

SUMMARY

  • Microsoft Certified Professional in Administering SQL Server 2016/ 2014/2012/2008 R/2008 with 8 years of experience as a SQL Server DBA in managing production and non - production environment.
  • Experienced in core DBA tasks; such as installation and configuration as well as designing and implementing disaster recovery procedures.
  • Hands on experience in Log Shipping and Database Mirroring.
  • Possesses over 3 years of experience with patching and server virtualizations, previously responsible for upgrading and installing patching on operating system and applications.
  • Well experienced on troubleshooting performance problems, fine-tuning of databases, and index analysis.
  • Strong experience in mentoring team members and writing detailed documentation.
  • Excellent problem-solving abilities, team player, ability to learn new emerging technologies & adapt quickly.

TECHNICAL SKILLS

RDBMS: SQL Server 2016/ 2014/2012/2008 R2/2008

Database Tools: SSIS, SSRS, DTS, BCP, ODBC, SQL OLEDB, Business Intelligence Studio, Data Service, Crystal Reports

Languages\Tools: Visual Basic, PowerShell, T-SQL

Operating Systems: Windows Server 2012, 2008R2, 2008, Windows 10/8/7

Modeling Tools: MS Visio and Erwin

Monitoring Tools: SQL Profiler, Performance monitoring and activity monitor

Third Party Tools: TOAD for SQL, LiteSpeed, Redgate, SQLcompare, SQLSafe and spotlight

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP

Other Tools: MS Visual Source Safe, Source Control, MS Visio, VMware, Jira, SharePoint, MasterData Services (MDS), Active Directory

PROFESSIONAL EXPERIENCE

Confidential - Asheville, NC

SQL Server DBA

Responsibilities:

  • Managed, monitored, installation and security of company databases.
  • Worked with Infrastructure Team on system incident reports.
  • Imported and exported data in support of customer implementations and requests ETL.
  • Training and Development of Database Team to support existing system(s).
  • After hours on-call, maintenance, and release availability required.
  • Ensured database integrity, stability, and availability.
  • Maintained database backup and recovery strategies.
  • Configured 2008R2 Pear to Pear replication.
  • Designed infrastructure changes for growth and high availability/disaster recovery strategies (HADR).
  • Enabled transparent database encryption (TDE) on a new server.
  • Exported server certificate and performed database cloning.
  • Administered SQL Server Reporting services (SSRS) including report design, advanced scheduling, and integrations.
  • Strong Transact SQL (T-SQL) programming skillset including writing stored procedures, functions,and maintenance scripts.
  • Performance tuning of complex stored procedures and database objects.
  • Skilled at identifying bottlenecks, design challenges and creating solutions.
  • Worked closely with Development and QA teams to optimize code and efficiency.
  • Monitored a SQL server daily database activity summary.
  • 24x7 Production on Call Support and performed other duties as needed.

Confidential - Pasadena, CA

SQL Server DBA

Responsibilities:

  • Installed, configured, administered SQL Server 2014/2012/2008 R2 production and development environments.
  • Worked on clustered virtual host and migrated to other hosts during the patching process.
  • Responsible for upgrading and installing patching on operating system and applications.
  • Determined if the patch corrects a problem or if it is a value that will benefit the company.
  • Reviewed the software dependencies and proof-of-concept test in a lab environment before the patch is applied to production system.
  • Monitored and managed the Table spaces and data files growth. Analyzed Tables & Schemas, collectedsystem statistics and rebuilt indexes.
  • Installed maintained & monitored production SQL servers and made sure they were up-to-date with latest rollup hot fix and service packs.
  • Installed and configured windows server 2012 failover clustering Active/Passive and configured Always-ON for High availability and (DR) disaster recovery solutions.
  • Designed and implemented log shipping, mirroring, and replication from primary site to the secondary site to support mission critical applications and offload queries.
  • Migrated multiple databases, SSIS packages, SSRS reports, SSAS cubes between different SQL versions 2014/2012/2008 R in both in In-place and Side-by-Side migration methods.
  • Moved several existing production databases, jobs, packages, reports, linked server, logins, and other computer objects to new versions of SQL server.
  • Worked closely with application team, development team and infrastructure team for planning and Implementation of the migration and for new application requirements\releases.
  • Experience on performance tuning, optimization of stored procedures, and queries.
  • Responsible for database Maintenance tasks such as index fragmentation, DBCC operations, monitoring performance and optimizing queries for maximum efficiency.
  • Monitored database system details within the database, including stored procedures and execution time and implement efficiency improvements.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
  • Migrated new database structures (tables/indexes/stored procedures) from test to production environment.
  • Automated database refresh from production to test using custom scripts.
  • Set up linked servers between SQL servers, DB2, and Oracle data sources.
  • Supported VMware and SharePoint back-end databases.
  • Created databases, Logins, Roles and granted appropriate permissions.
  • Worked with offshore team on pending issues and coordinating migration project activities to meet the project deadlines.
  • Developed and deployed SSIS packages and SSRS reports.
  • Managed windows and SQL database users/groups accounts using Active Directory.
  • Handled day to day support tickets and development issues.
  • 24x7 Production on Call Support and performed other duties as needed.

Environment: SQL Server 2014/2012/2008 R2, Windows server 2012/2008R2, Backup Utility (netbackup), SSRS/SSIS, Quest, SQL Litespeed, Idera technologies Like SQL secure, VMware, SharePoint, Master Data Services (MDS).

Confidential - Rockville,MD

SQL Server DBA

Responsibilities:

  • Actively participated in gathering Business Requirements and System Specification from users.
  • Performed Day to day database maintenance operations, SQL server database backup & restore, point in time recovery, job scheduling in a real-time production and Stage environments.
  • Oversaw backup, clustering, mirroring and failover and send (automate) daily status report and confirm that the database is up and running as expected.
  • Involved in partition of the tables, Index to improve the performance, estimated the table space to hold the ETL process and bulk data flow from source to target.
  • Fine tuning of database objects and server to ensure efficient data retrieval.
  • Involved in performance tuning, optimization of stored procedures and queries.
  • Troubleshoot database performance issues and tune database objects by using traces and profiler.
  • Proficient in working with production change management and change control procedure.
  • Developed various T-SQL stored procedures & functions for data validation process.
  • Created and maintained various databases for Production, Development and Testing using SQL Server and planning the location of data, index, and Transaction log files on the disk.
  • Supported Development team in deploying and testing the application.
  • Experience in contacting Microsoft and other vendors for product and technical support.
  • Provided 24x7 support to SQL application developers in implementing the applications on production server.

Confidential- Boston, MA

SQL Server DBA

Responsibilities:

  • Development of automated daily, weekly and monthly system maintenance tasks such as database backup, Mirroring, database integrity verification, indexing and statistics updates.
  • Implemented the Data Collector to capture the CPU, DISK, Memory counters.
  • Implemented table partitioning to improve performance and data management.
  • Implemented database and SQL Query Tuning to improve performance of loads.
  • Reduced the deadlocks by using the SQL Server Profiler hence the performance of the query is tuned.
  • Created automatically running stored procedures for day-end operation using SQL Server agent
  • Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
  • Provided daily support, troubleshooting, monitoring, optimization and tuning of server, and SQL server environments across entire system.
  • Created logins and roles with the appropriate permissions.
  • Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
  • Successfully implemented database mirroring between Primary server and Mirror Server.
  • Implemented log shipping to support DR servers, worked on high availability concepts like and clustering.
  • Assisted in maintaining and updating the SharePoint platform.
  • Provided 24x7 dedicated supports for SQL Server production server.

Hire Now