SUMMARY

• Highly motivated Database Administrator with 6 years experience in Installation, Configuration, Upgrade, designing, deploying, and managing and monitoring Microsoft SQL Server database from Development to production environment.
• Expert level knowledge in SQL Server ETL process using SQL Server Integration Services and Export/Import utility.
• Ability to plan designed and Implement any given SQL Server Backup Strategy/Policy.
• Have the ability to work well independently with minimal direction, excellent communication skills and the ability to work/collaborate with people in a team setting

TECHNICAL SKILLS

• DDL, DML, and DCL
• SQL Server 2005, 2008R2, 2012 & 2014,2016
• Windows Server 2008R2 and 2012R2

PROFESSIONAL EXPERIENCE

Sr. SQL Server DBA

Confidential - Washington, D.C.

Responsibilities:

• Extensive knowledge of configuring database mail in SQL Server 2008r2, 2012,2014, 2016
• Implemented SQL Server mail notification and database alerts for all scheduled jobs.
• Strong experience in Database capacity planning, implementing backup and recovery strategy for SQL Server databases.
• Extensive experience in documentation practices, to use as company SOP
• Installed, configured, deployed and managed MS SQL Server 2008, 2008R2, 2012, 2014 and 2016 on both production and test database instances
• Expert knowledge in SQL Server SSIS ETL processes, including documentation for the ETL process.
• Created Linked Servers between SQL server and Oracle
• Changed the passwords for remote users of linked servers as requested by customer
• Performed migrations of linked servers between Servers
• Working knowledge of identifying and correcting performance issues
• Worked with Jira to track, manage, and document bugs, blockers, tasks in order to maintain assigned tasks organized and delivered on time.
• Expert knowledge in creating automated maintenance Plan for SQL Server 2008r8/2012/2014 & 2016 versions.
• Experience in monitoring and tuningSQL Server database performance using SQL Profiler, DMV's, DMF's, Database Tuning Advisor and Windows Performance Monitor.
• Experience in configuring an active directory and domain server on a virtual environment
• Experience in troubleshooting networking issues between computers on a active directory domain and server
• Expert knowledge of Transact- SQL (data definition language and data manipulation language)
• Implemented and managed Mysql database backups & recovery, performance monitoring and tuning.
• Extensive knowledge in maintaining SQL Server and Windows authentication modes for logins, granting proper privileges and managing user/server define roles.
• Experience in working in collaborative team environment with Developers, Business Analysts, Business intelligence and a Project Management team.
• Working knowledge of SQL Server Reporting services, managing and updating SSRS with new Data.
• Configured and executed newMySQL server migration
• Performed Multiple database restore using MySQL dump operation as needed by Application Admins/developers
• Experience in administering MySQL databases using phpMyAdmin
• Expert knowledge working with MySQL work bench

SQL Server DBA

Confidential

Responsibilities:

• Installed, configured, deployed and managed MS SQL Server 2008, 2008R2, 2012 & 2014 on both production and test environments both on-site and remotely.
• Used Visual Studio to create SSIS and SSRS and modify maintenance plan packages
• Expert knowledge in SQL Server SSIS packages
• Extensive working knowledge on managing and maintaining data warehouse databases
• Expert knowledge in database ETL processes
• Implemented Transparent Data Encryption (TDE), Column-Level, Encryption, and Secure Sockets Layer encryption
• Experience in implementing and managing transactional, merge, peer-to-peer and snapshot Replication models.
• Performed database refresh from production to development and production to test
• Excellent skills in database backup, recovery, and Log Shipping.
• Expertise in creating and managing databases and users. Evaluating user permissions and granting access to authorized users using least privileges policy.
• Performed database migration from SQL server 2008/R2 to SQL Server 2012.
• Managed database security, permissions and administer security for logins for both Windows and SQL accounts.
• Extensive experience with SQL Server 2012 new features and SQL Server Policy-based Management.
• Used Dynamic Management Views (DMV) to monitorSQL Server health during runtime, troubleshoot the performance bottleneck/issues and proactively worked to minimize downtime
• Implemented High Availability and Disaster recovery using clustering, mirroring, log shipping, and Always ON Availability Groups
• Created numerous queries involving self joins, correlated subqueries, tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
• Troubleshooting and resolving database integrity, performance issues, blocking and deadlocking issues.
• Recovered the databases from backup in disasters and implemented Point-In-Time Recovery solutions.
• Experience with Indexes, index management, integrity checks, configuration, and SQL Server patching.
• Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers.
• Designed database maintenance plans to set up core maintenance tasks to make sure databases performs well, are regularly backed up in case of system failure and are checked for inconsistencies
• Performed defragmentation and rebuilding of indexes periodically on the production server
• Experience in configuring backups, history clean up task and rebuild indexes.
• Worked in a team to analyze business requirements and systematically designed various databases that store customers data and their related transactions

SQL Server DBA

Confidential

Responsibilities:

• Performed multiple Installations of SQL Server 2008 and deployed SQL Server database patches as needed
• Performed database design, creation, and data modeling.
• Installed and configured a SQL Server database in a AWS environment
• Created Database Maintenance plans, SQL Agent jobs, stored procedures and SSIS packages.
• Performed and managed the database backup and recovery.
• Enforced Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Experienced in Database capacity planning, in order to create and implement disaster recovery strategy
• Extensive knowledge of ETL processes
• Worked together with application developers to manage to assign
• Created appropriate database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
• Performed maintenance of the clustered and non-clustered indexes.
• Created and monitored jobs history for maximum availability of data and ensure consistency of databases.
• Reviewed theSQL Server Error Logs and Application Logs as required to resolve any apparent issue.
• Worked with IBM BPM to claim, work, reassign, close and manage tickets that were assigned to me
• Engaged in the troubleshooting of SQL Server issues.
• Implemented and scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures for task completion and success.
• Was available 24x7 to provide mission critical production support of servers including production, test and development servers
• Wrote, maintained, and monitored appropriate SQL Jobs and ETLs as needed to transform and load data feeds from and to vendors and clients