SUMMARY

• Highly motivated Database Administrator wif 6 years experience in Installation, Configuration, Upgrade, designing, deploying, and managing and monitoring Microsoft SQL Server database from Development to production environment. Expert level noledge 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. Has teh ability to work well independently wif minimal direction, excellent communication skills and teh ability to work/collaborate wif people in a team setting
• 6 Years of IT experience
• 6 Years hands on Database experience
• T - SQL Programming Language, DDL, DML, and DCL
• Expert Level experience in SQL Server 2005, 2008R2, 2012 & 2014,2016
• Knowledge of Windows Server 2008R2 and 2012R2
• Subject Matter Expert in SQL Server ETL using SSIS, SSRS and Visual Studio, Oracle Virtual box, VMware, MYSQL, MYSQL Workbench, phpMyAdmin, AD/DS, Linked Servers

PROFESSIONAL EXPERIENCE

Sr. SQL Server DBA

Confidential - Washington, D.C

Responsibilities:

• Extensive noledge 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 noledge in SQL Server SSIS ETL processes, including documentation for teh ETL process.
• Created Linked Servers between SQL server and Oracle
• Changed teh passwords for remote users of linked servers as requested by customer
• Performed migrations of linked servers between Servers
• Working noledge of identifying and correcting performance issues
• Worked wif Jira to track, manage, and document bugs, blockers, tasks in order to maintain assigned tasks organized and delivered on time.
• Expert noledge 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 noledge of Transact- SQL (data definition language and data manipulation language)
• Implemented and managed Mysql database backups & recovery, performance monitoring and tuning.
• Extensive noledge 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 wif Developers, Business Analysts, Business intelligence and a Project Management team.
• Working noledge of SQL Server Reporting services, managing and updating SSRS wif 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 noledge working wif 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 noledge in SQL Server SSIS packages
• Extensive working noledge on managing and maintaining data warehouse databases
• Expert noledge 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 wif SQL Server 2012 new features and SQL Server Policy-based Management.
• Used Dynamic Management Views (DMV) to monitorSQL Server health during runtime, troubleshoot teh 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 teh databases from backup in disasters and implemented Point-In-Time Recovery solutions.
• Experience wif 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 teh 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 teh 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 noledge of ETL processes
• Worked together wif application developers to manage to assign
• Created appropriate database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
• Performed maintenance of teh 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 wif IBM BPM to claim, work, reassign, close and manage tickets that were assigned to me
• Engaged in teh 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