Sql Server Dba Resume
Houston, TexaS
SUMMARY
- A Skilled and well - experienced SQL SERVER DBA professional with 5+ years of experience in delivering high-quality services in SQL SERVER Database Administration and I have accomplished projects as per user requirements (SLA) and I am a highly effective team-oriented able to collaborate with cross-functional personnel at all levels.
- Deployed Database, development, testing, UAT and production database server
- Created Tables, Views, Functions, Triggers and store procedures.
- Migration Database from MS access to SQL Server
- Managing Data Integrity ion
- Experience with Database 3rd part Tools like, SQL navigator and Toad
- Managing Security
- Implementing & Managing Database High Availability and
- Implementing Effective Backup Strategies For Disaster Recovery /Replication
- Database Performance Tuning & Query Optimization
- Troubleshooting & Problem Solving
- Experience in Patch Script, Using Dos and Power shell
- Deployed Service Pack SQL Server
- Documentation
TECHNICAL SKILLS
RDBMS: Microsoft SQL Server 2005/2008/2012 , MS Access
SQL Server Technologies & Tools: Management Studio, SQL Profiler, ETL, Database Tuning Advisor (DTA) SSIS, SSRS &SSAS
Case Tools: MS Office
ETL Tool: SSIS
PROFESSIONAL EXPERIENCE
Confidential, Houston, Texas
SQL Server DBA
Responsibilities:
- Developed, tested & implemented a robust database backup and recovery strategy
- Managed security by defining roles and rights.
- Upgraded/migration Database from SQL Server from lower to higher versions.
- Installed & configured multiple SQL Servers.
- Performed database upgrades & applied software patches to databases as per user requirements.
- Provided appropriate access to client so that they will have access to their respective needed server and database objects.
- Set up or created, maintained and administered maintenance plans and jobs.
- Implemented & managed DR/Availability technologies including replication, Log Shipping, database Mirroring, failover clustering and Always On as per the requirement.
- Conducted root cause and analysis for database incidents and problems.
- 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.
- Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures etc.
- Created the SQL Server Integration Services (SSIS) and DTS Packages for data import and export.
- Supported the research, investigations and recommendation of best practices for information and application services, and contribute to work plans.
Environment: MS SQL Server 2012/2008R2/2005,T-SQL,SSIS,SSRS,ReportBuilder, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Always On, Windows XP/2000 and Windows 2003/2008/2012 Server.
Confidential, Houston, Texas
SQL SERVER ADMINISTRATOR
Responsibilities:
- Engaged and involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Index maintenance, database health and consistency check, Security maintenance etc.
- Involved in Install, configure, monitor, upgrade, patch and tune SQL Server 2008, 2008/R2 & 2012 servers.
- Upgraded/migration Database from SQL Server from lower to higher versions.
- Worked as team player in resolving issues, documentation etc.
- Security Administration: creation of users, Roles and granting appropriate privileges
- Worked on debugging and troubleshooting the database issues.
- Performed Performance Tuning of the database, Stored Procedures and SQL queries.
- Implemented patching of critical servers\instances.
- Involved in designing, configuring, monitoring and troubleshooting replication, log shipping and mirroring on critical databases and quickly resolving issues.
- Monitor and tune of SQL Server infrastructure like Disk, CPU, Memory, SQL Code etc., by using Perfmon, Profiler, DMVs & DMFs
- Created the SQL Server Integration Services (SSIS) and DTS Packages for data import and export.
Environment: MSSQL Server 2005/2008/2008 R2/2012, MS-Access, MS Excels, SSIS, SSRS, T-SQL, SQL Profiler…
Confidential, Houston, Texas
SQL Server DBA
Responsibilities:
- Responsible for the implementation and maintenance of database backup and recovery processes.
- Involved in designing, configuring, monitoring and troubleshooting of HADR technologies such as failover clustering, replication, log shipping and database mirroring on mission critical databases and quickly resolving issues.
- Monitor all instances of the server are up and running.
- Monitor SQL job failures and resolve.
- Monitor the performance and manage the parameters to give fast responses to users.
- Install and test the new version of database management system.
- Write documentation for a database including data standards, procedures and metadata.
- Control privilege and permission for Server and database level access.
- Checking the integrity and health of databases.
- Monitor SQL job failures, debug and resolve.
Environment: MSSQL Server 2005/2008/2008 R2, MS-Access, MS Excels, SSIS, SSRS, T-SQL, SQL Profiler…
Confidential, Houston, Texas
Junior SQL Server DBA
Responsibilities:
- Responsible for the implementation and maintenance of database backup and recovery processes.
- Involved in designing, configuring, monitoring and troubleshooting replication, log shipping and mirroring on mission critical databases and quickly resolving issues.
- Monitor all instances of the server are up and running.
- Monitor SQL job failures and resolve.
- Monitor the performance and manage the parameters to give fast responses to users.
- Install and test the new version of database management system.
- Write documentation for a database including data standards, procedures and metadata.
- Control privilege and permission for Server and database level access.
- Checking the integrity and health of databases.
- Monitor SQL job failures, debug and resolve.
Environment: MSSQL Server 2005/2008/2008 R2, MS-Access, MS Excels, SSIS, SSRS, T-SQL, SQL Profiler…