Database Administrator Resume
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.