Sql Server Dba Resume
Santa Fe, NM
SUMMARY
- Microsoft Certified Professional in Administering SQL Server 2012 with 5+ years of experience as a SQL Server DBA in managing production and non - production environment.
- Expertise in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and Database issues.
- Extensive experience in managing MS SQL Server on Windows 2000/2003/2008/2012 Servers.
- Used DMVs and DMFs for monitoring and troubleshooting performance issues.
- Expert level knowledge in Server Consolidation and Data Center migrations.
- Implemented Database Mirroring and Log Shipping configuration to provide HA/DR solution.
- Managed SQL Servers running on VMWare ESX hosts.
- Define and implementETLdevelopment standards and procedures for data warehouse environment.
- Adept in designing and implementing Backup and Recovery Strategies.
- Developing reports onSSRSon SQL Server.
- Implemented different types of Replication models like Transactional and Snapshot.
- Proficient in upgrading (In-place Upgrades) and migrating databases from MS SQL Server and SQL Server /2012/2014.
- Create Database(s) on SQL AZURE.
- Designed, tested and debugged external and DB2 native stored procedures
- Deep KnowledgeSQL Server Integration Services(SSIS) and SQL Server Reporting Services (SSRS)with good knowledge onSQL Server Analysis Services(SSAS).
- Designed DR plans while satisfying SLA requirements and conducted DR tests.
- Knowledge in Third party tools like TOAD, Remedy and Foglight.
- Worked in production support role to provide 24/7 on-call support.
- Proficient in migrating databases from SQL Server to Oracle.
- Hands on Experience in installing and configuring Active/Passive Cluster.
- Worked with tools like SQL Profiler, Windows Perfmon and Performance counters for Monitoring and Tuning MS SQL Server Performance.
- Expertise in SQL server technologies for Clustering, non-clustering, High Availability and Disaster Recovery.
- Sound understanding of change control and helpdesk ticketing processes.
- Applied Service packs and hotfixes during off hours.
- Skilled in using LiteSpeed and Redgate to backup and restore the SQL databases.
- Conversant with all phases of Software Development Life Cycle (SDLC).
- Flexible and enthusiastic team player with excellent communication and leadership skills.
TECHNICAL SKILLS
Languages: T-SQL, Visual Basic, Java, C#.NET, VB Script, Java script
RDBMS: MS SQL Server 2014/2012/2008/2005/2000 and Oracle 11g
Web Servers: IIS, Weblogic
Operating Systems: Windows 2012/20, Windows NT
Backup and Restore Tools: Idera SQLSafe, Redgate, Litespeed
Monitoring Tools: Spotlight for SQL Server
Others: Microsoft Office Suite, Microsoft Visio, Trello, Tableau,Microsoft Project
PROFESSIONAL EXPERIENCE
SQL Server DBA
Confidential, Santa Fe, NM
Responsibilities:
- Responsible for Installing SQL Server on new servers (2008/2012/2014 ).
- Upgrading existing 2005/2008 Production Server to SQL Server 2012/2014 Version.
- Moving several of the existing SQL 2005/2008 Production databases, jobs, packages, linked server and logins to new versions of SQL server.
- Installed and maintained MS SQL Server 2000 on Windows 2003 Server. Worked on SQL Server 2000 failover clustering which is built on top of a Windows 2003 server cluster.
- Upgrading SSIS Packages to SQL Server 2012 version.
- Designed Schemas using Microsoft Visio.
- Handling day to day support tickets and development issues.
- Set up linked servers between SQL servers and oracle data sources.
- Supported application programmers and users in their daily interactions with DB2.
- Responsible for On-call support and support escalation from offshore.
- Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
- Working with Offshore team on pending issues and coordinating migration project activities to meet the project deadlines.
- Monitor database systems performance, capacity and availability.
- Database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.
- Solid experience onhigh availabilitySQL Server solutions, includingReplication Models(Snapshot/Transactional) andSQL Server clustering(Active-Active, Active-Passive).
- Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
- Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
- Configuring, maintaining and troubleshooting Windows Server 2008 R2, SCCM 2007/2012 .
- Performing regular SCCM Health Checks of Site Server.
- For data mining applications, worked with SQL Server Analysis Services.
- Responsible for database refresh and coordinating with QA Team.
- Developed Documentation using Microsoft Office.
- Used the tool BMC Remedy user by the BMC software in resolving the incidents in the development servers and the production servers
- Developed and deployed SSIS packages and SSRS Reports.
- Extracted data from internal data warehouse system to SSRS.
- Proactive monitoring of SQL server known issues related to performance.
- Writing Custom scripts to refresh tables and monitoring jobs.
- Troubleshooting performance issues in production and non-production servers.
- Providing support for database mirroring, always on and log shipping implementation.
Environment: MS SQL Server 2014/2012/2008 R2/2005, RedGate, T-SQL, Windows Server 2012/2008/2003 , SSIS, SSRS, Microsoft Office.
SQL Server DBA
Confidential, Wilmington, DE
Responsibilities:
- Installed and configured SQL Server R2 in production and development.
- Upgraded SQL Server 2000 to SQL server 2005/2008 in 32 and 64-bit environment.
- Actively involved in installing and managing multiple 2 node failover cluster set up in active/passive environments as a High Availability mechanism.
- Successfully implemented database mirroring with high availability mode for critical systems.
- Implemented log shipping from primary server to standby server to support DR solution.
- Troubleshoot database performance issues and tune database objects. Set up traces and profiler to troubleshoot performance issues.
- Used DTS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
- Recovered databases in the event of a disaster by developing and maintaining relational structures including backup/recovery and log shipping procedures.
- Generated Performance analysis reports for all the prod servers on a weekly basis using third party tool Quest FogLight.
- Reviewed andoptimized SQL queries, CDC,stored procedures, functions, Indexes, views and triggers.
- Experience with third party tools like FogLight and Veritas Netbackup.
- Configured 43 Production servers using FogLight monitoring tool.
- Created ad-hoc reports.
- Created and managed clustering environment such as active/passive clustering.
- Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
- Configured transactional Replication from multiple subscribers for reporting purposes.
- Involved in performance tuning, optimization of stored procedures and queries.
- Proficient in working with change management and change control procedure.
- Created and maintained various databases for Production, Development and Testing using SQL Server 2005.
- Planning the location of data, index, and Transaction log files on the disk.
- Solved issues related to server performance and disk space.
- Involved in the design and development of the SSAS cubes.
- Supported Development team in deploying and testing the application.
- Experienced in contacting Microsoft and other vendors for product and technical support.
- Provided 24*7 support to SQL application developers in implementing the applications on production server.
- Conducted root cause analysis of application availability and narrowed down to issues related to coding practices, database bottlenecks, or network latency.
Environment: Microsoft Windows Server bit, Microsoft SQL Server 2000/2005/2008 and Microsoft Visual Studio, Performance Monitor, Profiler and DTA.
SQL Server DBA
Confidential
Responsibilities:
- Installed and configured SQL Server 2005/2008.
- Upgraded SQL 2000 and 2005 Server to SQL 2008 (In place and Side-by-Side) server for high volume processing databases.
- Worked closely with application owners, development teams and other teams for planning and implementation of the migration.
- Designed and Implemented Disaster Recovery Procedures.
- Implemented High Performance Database mirroring on SQL 2005 database servers.
- Automated database refresh from production to test using custom scripts.
- Created custom jobs to back up the databases, maintenance tasks using custom scripts.
- Estimated disk storage requirements for database software, database files.
- Created databases, Logins, Roles and granted appropriate permissions.
- Configured Database Mail and created profiles for business applications to send out notifications.
- Developed and deployed SSIS packages and SSRS Reports.
- Installed and Configured 2- node High availability SQL Active/Passive clusters.
- Worked with 3rd party vendors to resolve database issues.
- Configured Log Shipping for high availability on SQL Server 2008
- Responsible for applying service packs and hotfixes
- Refreshed databases from production to test, stage and development environments.
- Provided on-call support.
Environment: MS SQL Server 2008 R2/2005/2000, Idera SQLSafe, T-SQL, Windows Server 2008/2003, TSM