SQL Server DBA
Resume:
Abdul-Rauf Oppong
Fort Worth, Tx 76123
***********@*****.***
Summary
I am a 5 YEAR experienced Microsoft SQL database administrator (DBA) with extensive experience in, administration, performance tuning, monitoring, high availability solutions and maintenance of SQL databases. I have been responsible for the development, design of database strategies, improving database performance and capacity planning for future expansion requirements. I plan and implement security measures to safeguard various production and development databases.
Management and Technical Skills Overview
Databases: SQL Server (2000, 2005, 2008,2008R2,2012,2014,2016)
Expertise: Database Mirroring, Disaster Recovery, Failover clustering, Integration Services, transact SQL Development, Replication, Performance Tuning, Reporting Services, troubleshooting, Database Upgrades, patches, Backup and Recovery, Database Security, Always on availability group and High Availability Solutions, DTS/ETL, SSRS, indexing, writing stored procedure’s tracing and profiling, windows server administration, PowerShell scripting
Operations support: 7x24, helpdesk, configuration management, SLA management
Management: strong leadership, direction, guidance, decision making, verbal and written communications
Professional Experience:
Dove Technology
SQL Server DBA
May 2016- Apr.2018
Performs database administration activities including; installation, configuration, capacity planning and space management
Upgrading database (in place and side by side)
Proactive and active performance monitoring and tuning of production databases
Taking reporting request through ticketing system
Making copies of databases for development and production testing
Developing Backup strategies and recovery solutions
Database maintenance tasks (rebuilding and reorganizing indexes, updating statistics, running integrity checks (DBCC), shrinking data files
Data migration (2005, 2008,2008R2,2012,2014,2016)
Setting up and administering Security (Creating Windows and SQL Server Logins, assigning appropriate server, database and schema roles and permission)
Working with developers, support and QA team to maintain all database environment
Scheduling maintenance jobs and backup
Creation of stored procedures, triggers, tables and indexes
High availability solutions
Setting up and monitoring Replication (transactional, snapshot and merge)
Setting up and monitoring Database Mirroring and log shipping
Perform technical analysis and troubleshooting on complex database problems
Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company database.
Troubleshooting production issues (performance, connectivity)
Developing SQL Server Integration Services (SSIS) packages
Developing Parameterized, tabular and matrix reports (SSRS)
SQL Query Tuning
Physical Database designing
Monitoring SQL server clusters (Active Active) and (active passive), Always on Availability group.
US Army
Health Care Specialist 68W
Fort Polk, LA
Jul 2012- Nov 2016
Supervised field and clinical medical facilities; assist with technical and administrative management of medical facilities under supervision of physician, nurse, and physician assistant; administered emergency and routine outpatient medical treatment to battle and non-battle casualties; assisted with outpatient care and treatment; maintained health records and clinical files. Managed Aid Station pharmacy, prescription refills and supply.
Combat Life Saving (CLS) Trainer.
Administered emergency treatment in the field
Assisted with outpatient and inpatient care
Assisted with nursing care of patients including medical examinations, recorded blood pressure, applied and removed surgical, wound and skin dressings.
Collected and prepared specimen for analysis, assisted in clinic and dispensary, administered immunizations
Assisted with treatment of patients with common diseases, provided emergency medical care, surveys and sort casualties
Assisted in the triage of mass casualties and performed duties related to emergency care
Touchstone wireless
Dallas/Fort Worth Center – Texas
Triage Production Lead/ Exception Clerk
May 2011–Jul 2012
Effectively utilized T-Mobile’s systems (i.e. Tom, T-Star, SAP, (DMW) Device Model Warranty, MyInsight, Streamline, Samson, VASA) to accurately receive and create Return Authorization (RA) for Touchstone’s I.C.E. System
Accurately provided detailed reports to T-Mobile and IT on data entry spreadsheets to capture all required information to process customer’s orders
Monitor and maintain inventory levels (WIP).
Provided exceptional Customer Service by identifying T-Mobile Customer's handsets and recording information in the customers’ accounts to ensure that the customer’s account is credited
Worked closely with the management team to ensure that all new processes are documented and followed correctly.
Collaborated with the management team to implement new in-house process on the insurance exception returns.
Provide training, feedback and support to all team members to help improve their quality of work
Prepare and implement daily triage production plan
ENI Oil & Gas Exploration & Production
Accra-Ghana
SQL DBA/SAP Admin
Oct 2008 – Dec 2010
Part of a team of professionals that worked on customer site to achieve set project goals and objectives.
Provide remote support to SQL Servers on customer sites of different companies.
Writing, debugging, and tuning Transactional SQL and stored procedures.
SQL Server database physical model creation and implementation (data type, indexing, table design)
Setting up and administering SQL Server Database Security environments using Profiles, database Privileges and Roles.
Database mirroring, clustering, replication and performance tuning
Database support in HA production data center
Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery and managing clusters of SQL servers.
Supervise all aspects of the assigned team including day-to-day supervision, performance evaluation, and assignment to IT Projects and/or Production Support functions.
Server consolidation and space management
Proactive and active performance monitoring and tuning
Designing backup and restore strategies and Disaster Recovery solutions
Implement security policy design for current and new applications.
Coordinate team meetings with groups for any new design/strategies.
Creating database design for new projects support.
24x7 production support
Coordinating and facilitating change review meetings and helping in the management of incidents according to SLAs
Developing information systems testing strategies, plans, or scenarios
Military Education:
Basic Combat Training Fort Sill, LA
Aug 2012 – Oct 2012
Health Care Specialist /EMT Fort Sam Houston, TX
Medical Education Training Campus (METC)
Oct 2012 – March 2013
Structured Self Development (SSD) 1 Fort Bliss, TX
SGM Academy
Education:
University of Ghana Accra - Ghana
Radiation Therapy
2003-2008
NIIT Technologies Database Administration
Accra-Ghana
2008
University of Texas, Arlington Arlington, TX
BSc University Studies
Major: Business Management
2017-2018
Contact this candidate