Sql Assistant
Resume:
David Molton
*************@*****.***
Silver Spring, Maryland,
Summary
Microsoft® Certified Professional with over 6+ years of extensive experience in Administering and Managing of multiple MS SQL Server Databases in Production and non-Production environments. Well experienced in supporting and managing SQL Server relational database management systems hosted on Microsoft Window 2003/ 2008/ 2008R2/ 2012/2019 servers running on Physical and Virtual hardware platforms in a 24 x 7 environment using native SQL tools and also proprietary third-party products.
Skills and tools used
Microsoft SQL Server 2017/2016/2014/2012/2008R2 Enterprise and Standard Editions, Windows 2012/2008R2, Clustering, AlwaysOn, Log Shipping, Replication, SQL Server Management Studio, SQL Profiler, Data Masking, Performance Monitor, SSIS, SSRS, Microsoft Visual Studio, Database Upgrade Advisor and now Microsoft Data Migration Assistant, Sentry One, Idera, Red Gate. DMV’s, DMF’s, Extended view
Achievements
• Optimized T-SQL query performance using SQL Profiler, Execution Plans, and DMV's.
• Effectively used database integration and reporting tools such as SSIS and SSRS to ensure data integration and reporting needs of the companies
• profound experience in implementing SQL Server backup and disaster recovery strategies to meet RTO and RPO of the companies.
• routinely ensured optimal performance of SQL servers through optimum configuration of SQL servers based on best practices.
• successfully analyzed, documented, planned, and upgraded SQL Servers as part of a major upgrade and migration project.
• implemented proactive measures to perform database maintenance before problem happens
• Contributed on the design and programming of databases and implementation of database management standards and principles
• effectively undertook performance tuning, backups, replication, deployment, capacity planning and optimization for SQL Server databases.
• Systematically gathered the needful documents for successful DB audits and made the necessary ratification of gaps.
• Ensured smooth function of SQL servers through proactive measures and effective monitoring with native and third-party tools
• Profound experience on managing the project I am responsible, communicating progresses, documenting best practices and effectively coordinating tasks with team’s over all plans.
David Molton
*************@*****.***
Silver Spring, Maryland,
Education and Certifications
• Bachelor’s Degree: Information Technology (Addis Ababa University)
• Microsoft Certified Database Administrator: Microsoft Certified Professional (MCP) Work Experience
DATABASE ADMINISTRATOR 03/2017 to present
SunTrust Now Truist, Atlanta, Georgia
• Maintain and administer Microsoft SQL 2012, 2014, and/or 2016/17 databases, related systems, and environments
• Develop and deploy database scripts for data quality, stability to support maintenance activities that meet or exceed Service Level Agreements (SLAs), RPO and RTO.
• Installation, security, configuration, migration, maintenance, monitoring, backups and recoveries of SQL Server software and databases
• Perform SQL Server database disaster recovery and high availability SQL Server solutions such as clustering, database mirroring, replication and log shipping
• Resolve database issues and performance tuning using SQL profiler and Database Tuning Advisor (DTA)
• Experience creating and debugging large Transact-SQL (T-SQL) database scripts
• Assess and improve the database performance, schema, manage indexes, produce roll up tables and views and alter speed indexes
• Collaborate with the application developers, architects and project team on logical and physical database design and implementations
• Responsible for 24x7 technical support of more than 300 instances of 64/32 bit SQL Server 2014/2012/2008/2005/ 2000 Enterprise/Standard infrastructure (Physical & Hyper-V) with Multi-Node Clusters (Active/ Passive), SQL Server Replication, Database Mirroring, Log Shipping, IBM SAN solutions, DPM backup, SCOM Monitoring.
• Worked closely with scrum masters, application developers, and system administrators for QC and production deployment in an agile environment.
• Successfully Upgraded (in place & side by side) SQL Server 2000/2005 to 2014, SSRS 2005 to SSRS 2014, DTS to SSIS.
• Performance monitoring/tuning SQL Server, TSQL, ETL process, & SSRS. - Analysis Disk, CPU & Memory bottle neck using SCOM, SQL Profiler, Perfmon, DMV, DMF & PAL.
• Automated SQL Server index maintenance, statistics update process, jobs, configured database mail, created alerts, operators and notifications and adhoc query recurrent reports through SQL Agent.
DATABASE ADMINISTRATOR 01/2014 to 02/2017
UNITED INSURANCE COMPANY ADDIS ABABA, ETHIOPIA
David Molton
*************@*****.***
Silver Spring, Maryland,
• Installation and Configuration of SQL Server 2012/2008/2008R2 on Production and Development Environments.
• Install service packs and patches on SQL server 2008/2012 boxes.
• Administer, maintain, develop and implement policies and procedures for ensuring Installation security and integrity.
• Troubleshoot SQL Server, database, production and non-production environment issues and errors.
• Assisting development teams with data cleansing, migration and loading in addition to assisting and supporting development teams with reviewing, building, testing and maintaining database structures and SQL scripts.
• Maintaining database environments, backup and recovery and performance tuning.
• Create jobs, alerts, log to monitor the database errors.
• Use SQL Agent to setup and automate internal processing tasks and backup tasks as well as setting up alerts to monitor the server and database health.
• Administer and schedule Backups and backup restoration strategies.
• Creating logins and users with appropriate roles, monitoring the user accounts.
• Creating groups, roles and granting the privileges.
• Automated routine database maintenance jobs like index defragmentation, statistics update, integrity checks, cleanup, monitoring etc jobs using SQL server agent.
• Monitor and fix replication issues.
• Use tools like SQL profiler, performance monitor to identify bottlenecks.
• Manage Space usage, Events, Jobs, customer complaints in the daily routine works.
Contact this candidate