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.