Sql Server Database Administrator
Resume:
Meraf A. Dobamo
***********@*****.***
Professional Summary
Results oriented DBA professional with 6 plus years of diverse experience in database design and systems development with proven expertise in database administration, design, development, and implementation. Well versed in supporting broad scale mission-critical database systems including configuring high availability, scalability, and disaster recovery.
Installation/Configuration
SQL Server Migration
Clustering
Database Optimization
High Availability
Disaster Recovery
Database Modeling
Automation, Implementation & Testing
Deployment of SSIS and SSRS packages
Performance Monitoring
Backup and Restore
PowerShell
Maintenance and
Troubleshooting
Value-Added Team
Leading
Leveraging Team Skills
Technical Skills
Installing, Configuring, and Administering MS-SQL 2005, 2008, 2008R2, 2012, 2012R2, 2014, 2016, and 2017 (testing status in production) on Standalone and Clustered environments.
Upgrading MS-SQL Server from older versions to newer versions.
Applying Service Packs and Patches (SPs) on servers.
Experience on configuring High Availability solutions such as Log shipping, Mirroring, Windows Failover Cluster, and in depth understanding on Always-On.
Implementing different types of Replication Models such as Snapshot, Merge, Transactional, and Peer to Peer (P2P).
Performing Full, Differential and T-Log backups as routine operations.
Preventing disaster events from occurring and to detect issues before they occur with Disaster Recovery Plans.
Extensive experience in Capacity Planning, Performance Tuning, and Trouble Shooting Procedures.
Configuring, deploying, scheduling, managing, and troubleshooting SSIS Packages.
Configuring & deploying package using SQL Server Reporting Service (SSRS).
Excellent commutations with multifunctional teams, programmers, and technical staff at all levels.
Ability to meet deadlines and yield effective results, while working independently and in teams.
Flexible and versatile to adapt to any new environment and work on any project.
Technical Environments
Relational DBMS:
Operating Systems:
Reporting and Auditing Tools:
Virtualization:
Applications:
ETL Tools:
Third-Party Tools:
DB Query Tools:
Hardware:
Microsoft SQL Server 2008/ 2008R2/ 2012/ 2014/ 2016, Microsoft Access, Oracle
Windows Server 2000/2008/2008R2/2012
SSRS, Report builder and SSDT, Idera SQL compliance manager and SQL secure
VM-Ware and Hyper-V
IIS, Visual Studio, SharePoint
MS SQL Server Integration Services (SSIS), Data Transformation services (DTS)
RedGate, Spotlight, Idera, Erwin, Toad, Solar Winds, SCOM
MS SQL Server Query Analyzer, SQL Profiler, ETL, SSMS, Enterprise Manager, PL/SQL Developer
IBM Power 750 Express Server, SAN-Clariion CX4 Model 480, NCUBE, AMD64, HP 3000, DEC Alpha, RS 6000, Sun 3's, Sun SPARCstations, VMS 6000, Alpha AXP
Professional Experience
Bank of America, Maryland DBA, 2016 – Present
Roles and Key Accomplishments
Installed, configured, and administered MS SQL server 2012, 2014, 2016, and 2017 (testing status in production).
Installed, configured, and managed VMware ESXi 5.5, 6.0 and 6.5
Successfully installed, configured, and administered a traditional SQL Server failover Cluster with 4 nodes.
Configured, added, and managed multiple databases on HA Groups with Always-On
Responsible for designing and implementing the backup strategy required as per the requirement on production and development environments.
Developed automated daily, weekly, and monthly SQL server agent jobs such as a database backup, integrity checks, and indexing maintenance and update statistics
Administered the MS SQL Server security in relation to users, logins, and groups, Principle of Least Privilege (PLP), Securable, Permission, Roles and Authentication Modes as a part of Security Policies.
Served as a “point of resolution,” closely monitoring disk space, system load, Disk IO, CPU, and memory usage to identify top SQL processes and troubleshoot performance issues.
Worked in close collaboration with other teams to rollout 60 deployments ranging from simple support to large and complex projects.
Wrote T-SQL Scripts to generate database performance related SSRS Reports.
Performed various troubleshooting methodologies to identify and resolve system and user related issues.
Implemented a DBA maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space) on production and test environments.
24 x 7 On-Call production support.
Environment: About 500 total servers each hosting small to very large size databases on both physical and virtual machines including; development, test, QA, and production servers. Tickets (JIRA, Team Track and Service Desk), Solar winds, SSIS packages, DBCC scripts
Department of Drivers Services, Georgia DBA, 2012–2016
Roles and Key Accomplishments:
Monitor current (as-is) manual/auto processes for efficiency, productivity, and access issues to quickly identify bottlenecks, performance delays, and gaps in the current process vs. the desired (to-be) process maps.
Minimize response time required to resolve system slowdown and system shutdown by troubleshooting issues related to database, connection issues, SQL server slow response, query issues, and permissions.
Safeguard organizational data with a physical standby for disaster recovery and logical standby for reporting in addition to managing security using SQL logins, roles, and security protocols for various users.
Optimize performance with upgrades such as the migration from SQL server 2008/R2 SQL servers to SQL server 2012, successfully integrating new features and improved database stability.
Improve efficiency with the creation of tools to interact with multiple databases that resulted in easy oversight of free space, data, system resources, and smooth facilitation of reports and deliverables.
Impact system performance by tuning long running queries to increase load time while adding additional indexes, changing access paths, rewriting queries, and adding partitioning.
Installation and configuration of Windows Server 2008/2008R2/2012/2014 including the set-up of Active Directory, Domain Controller, DNS and DHCP servers and Windows failover cluster.
Installation, configuration, and administration of SQL Server 2005, 2008, 2008R2, 2012 and 2014.
Creating and managing databases, schema objects such as tables, views, indexes, procedures, triggers and database constraints to meet business requirements and policies and maintained referential Integrity.
Implemented SQL server high availability solutions/tools like Log shipping, Mirroring, and Replication as well as carefully scheduled maintenance plan.
Installed and configured a traditional SQL Server failover Cluster with 4 nodes.
Configured, added databases, and managed Always-On High Availability Disaster Recovery techniques.
Created SSIS Packages for Data Flow, Object Migration and Database Maintenance.
Design, Develop and Implement SQL Server Reporting Service that extracts data and present in the user-friendly formats.
Created complex stored procedures, help developers to optimize queries, triggers, database design and UDFs to support efficient data storage and manipulation.
Created linked servers to perform distributed queries and data transfer.
Apply SQL Server patches, Service Packs, and Cumulative Updates as required and created documentation for tracking.
Monitored health of databases (OEM) and analyzed key performance metrics while also creating automated scripts for additional monitoring.
Assisted developers in the process of Extract, Transform, and Load (ETL) in data warehouse.
Run DBCC commands to check the database consistency and shrink the databases.
Manage Very Large databases (VLDBs) of 1TB and more using Table Partitioning, Backup and data Compression and Multiple file-groups.
Overall follow-up of the system and user support to address any issues and plan for potential problems in advance.
Provided 24x7 on call production support.
Environment: About 600 servers both in production and non production settings, on physical and virtual machines, MS SQL Server 2005, 2008 R2, 2012, and 2014, SQL Profiler, System/ Performance Monitor, Activity Monitor, ETL, Quest spotlight, SQL Lite speed, PowerShell, SSRS, SSIS, SSAS, Hyper-V, Data Warehousing, High Availability/Always On, Visual Studio, SharePoint and Others.
Education & Certifications
BSc, Information Technology, Georgia Gwinnett College
Certified, Microsoft SQL Database Administration
Professional Affiliations
Member, IACSIT, 2012. International associations of computer science and information technology (IACSIT)
Member, SQL Server Central, 2012, a community of more than 1,600,000 SQL server
Member, MSDN: https://msdn.microsoft.com/en-us
Contact this candidate