We provide IT Staff Augmentation Services!

Database Administrator Resume

4.00/5 (Submit Your Rating)

AtlantA

SUMMARY

  • 9 years of overall experience in Design, development and administration of database systems using Microsoft SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 .
  • Extensive experience of installation, configuration, maintenance, and daily administration for very large and complex databases in SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005.
  • Experience with Installations, Configuring SSRS and SSIS.
  • Experience in performing Migration and Upgrades from and, 2012 and 2014. In - place upgrades process and as well as side-by-side upgrades process.
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
  • Worked on data Extract, transformation and loading (ETL) using SSIS.
  • Firm experience of SQL Server High Availability and Disaster Recovery including SQL Server and Windows clustering, Database Mirroring and Log Shipping Transactional Replication.
  • Implemented the SQL Server mechanisms like data compressions, Database encryption, online indexing, Contained Databases, security principals and AlwaysOn.
  • Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
  • Experienced in migrating SSIS and SSRS.
  • Experience in setting up High Availability techniques like Log Shipping, Database Mirroring, Failover Clustering, Replication and AlwaysOn as per business requirement.
  • Installed Failover Clustering on multiple nodes on Active-Passive, Active-Active environments.
  • Expertise in handling migrations across different servers and managing Data Center Migrations along with managing security, logins, jobs and maintenance plans.
  • Created jobs, alerts, operators and notifications by automating alerts using the Database Mail and SQL Server Agent.
  • Good experience in Gathering and Analyzing Business Requirements to deploy database change scripts provided by customers and third party vendors.
  • Involved in debugging and testing of reports in SQL Server Reporting Services (SSRS)
  • Converted Data Transformation Services (DTS) packages to SQL Server Integrated Services (SSIS).
  • Experience in scheduling maintenance tasks like Index/Statistics Maintenance, Backups/Restores, DB integrity checks, tracing long running/deadlock queries, Capacity planning, Monitoring and tuning Tempdb, Cleanup tasks, Patch and hotfix installations, Disaster recovery solution maintenance etc.
  • A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

  • SQL Server Enterprise
  • WServer2016/2012R2/2012/2008R 2/2008/2003/2000
  • Visual Studio
  • Power BI
  • SSIS
  • SSRS
  • ActiveDirectory
  • MS Office
  • SQL Profiler
  • MySql
  • SCOM
  • Solarwinds
  • Litespeed
  • C# .Net
  • Python
  • Azure
  • NoSQL.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

Database Administrator

Responsibilities:

  • Migrated production databases from as a part of consolidation project.
  • Setup and configured SQL cluster and standalone environments on 2014 version.
  • Setup maintenance plans on all the new environments which include native backups, index optimization and disk monitoring.
  • Involved in design and development of SSIS packages.
  • Worked on performance issues related to SSIS jobs.
  • Setup and configuration of ASP session state databases.
  • Applied patches and cumulative updates to 2008, 2012, 2014 standalone and clustered instances in Prod, QA and Dev environments.
  • Performance tuning on slow running queries and root cause analysis.
  • Configured SSIS services, Database mail and alerts.
  • Populated and extracted data from excel to SQL tables using SSIS.
  • Worked on replication issues (Snapshot & Transactional).
  • Created SSRS reports based on requests of customers.
  • Supported around 100 SQL instances across different networks.
  • Worked on issues related to linked servers.

Confidential, Deerfield IL

Sr. SQL Server DBA/Developer

Responsibilities:

  • Migrated 25 production databases to new data center and upgraded the databases from 2000/05 to 2012 and 2014 versions. Migrated users, logins and orphan users.
  • Worked with developers, business analysts and dba’s to conduct design reviews and validate developed models.
  • Setup Clustering and mirroring on couple of application servers.
  • Scheduled maintenance plans for regular backups, statistics update and Index optimization.
  • 24/7 support based on the service now incidents and tickets.
  • Developed dashboards to regularly monitor disk space, database growth and other parameters using SSRS.
  • Grant permissions to the users and developers on databases and objects including tables, views, functions and stored procedures.
  • Data import/export using SSIS.
  • Created SSIS packages using transformations like lookups, Merge join, conditional split, for each loop, union all etc.
  • Designed and created views and stored procedures to join multiple tables for references.
  • Coordinated with ETL team to analyze and provide solutions to data issues.
  • Worked with developers on deploying changes to scripts, procedures.
  • Migrated databases to azure and configured databases on SQL Server 2014.
  • Performance review and tuning using SQL profiler, performance monitor and triggers.
  • Created SSIS reports for job failure notifications.
  • Worked on writing and modifying stored procedures, UDF’s, triggers and views.
  • Applied service packs on 2008R2 and 2012 SQL instances.

Environment: Windows 2012/2008R2/2003, SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Visual Studio, SQL Profiler, Oracle 12c and Solarwinds.

Confidential, Houston TX

SQL Server DBA

Responsibilities:

  • Installed and administered clustered and stand-aloneSQLserver 2012 and 2008 r2.
  • MigratedSQLserver 2005/2008 databases toSQLserver 2012.
  • Using third party tools such as questlite speed, fog light performance analysis and spotlightfor backups and monitoring.
  • Worked on SQL server profiler, SQL server agent, and database engine tuning advisor.
  • Developed SSIS Packages for data transfer from Oracle databases to SQL databases.
  • Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
  • Decommissioned unused servers post migration.
  • Worked with QA on testing procedures and environment setup for testing.
  • Worked withSQLserver utilities, backup procedures and recovery processes,SQL transactional replication and log shipping

Environment: MS SQL server 2005/2008/2008 r2/2012, enterprise, windows server 2003/2008, business intelligence development studio - SSIS, SSRS, quest litespeed and spotlight.

Confidential, Dallas TX

SQL Server DBA

Responsibilities:

  • Installed and maintained SQL server 2012/ 2008r2/ 2008 on windows 2003/ 2008 servers.
  • Created and deployed SSRS reports on failed backup jobs.
  • Administrated the SQL server 2012/2008/2005 servers in production, pre-production, non-production databases, front end application support and performance analysis/tuning.
  • Worked on developing and deploying SSIS packages.
  • Worked on migrating SSIS packages.
  • Performed functions like indexing, backup restore, and query tuning, monitoring, optimization
  • Troubleshooting and resolved application issues, database performance and deadlocking issues.
  • Responsible for disaster recovery/high availability planning and backup/restore.
  • Worked with developers to do the database schema changes and database restore requests
  • Analyzed the tables and rebuild the indexes whenever needed to improve the performance.
  • Performed full, differential database backups and transaction log backup.

Environment: MS SQL server 2005/2008/2008 r2, windows server 2003/2008, business intelligence development studio - SSIS and SSRS.

Confidential, Dallas TX

SQL Server DBA

Responsibilities:

  • Upgrade of databases from R2 and 2012 versions.
  • 24/7 support for production databases.
  • Worked on database performance issues.
  • Compliance on database and server levels.
  • Monitor scheduled database maintenance jobs regularly.
  • Worked on disk space issues and storage planning.
  • Database support for BI (SSIS and SSRS).
  • Review database size growth and disk spaces regularly.

Environment: MS SQL server 2005/2008/2008 r2/2012, litespeed, windows server 2003/2008/2012 , visual studio, business intelligence development studio - SSIS and SSRS.

Confidential

Intern/ Jr. SQL Server DBA/Developer

Responsibilities:

  • Installation and configuration of 2005 and 2008R2 versions of SQL Server.
  • Database maintenance including regular backups, index and query optimization.
  • Performance tuning for resolving slow running queries and timeout issues.
  • Worked with developers to deploy scripts and table changes.
  • Developed complex views and stored procedures.
  • Data transfer from flat files and CSV to SQL tables using SSIS.
  • Migrated DTS packages to SSIS.
  • Security policies, login issues and database permissions.
  • Documentation about existing sql environment and changes.

Environment: MS SQL server 2005/2008/2008 r2, windows server 2000/2003/2008.

We'd love your feedback!