Sql Server Manager
Resume:
Moses Patrick
Database Administrator
********@*****.***
SUMMARY OF QUALIFICATIONS AND BACKGROUND
I have 10+ years experience as a Database Administrator, and experience as
an SQL Server DBA, Oracle backup and recovery using RMAN. I have experience
working in a fast paced, detail oriented environment, while developing
quality control measures that immediately improved integrity and
consistency of data. I am a skilled problem solver who works well
individually or as a member of a team. I also bring customer service
experience in resolving data related issues to the program. I am a lifetime
learner committed to making an immediate contribution to your company.
TECHNICAL ACCOMPLISHMENTS
Migrated all SQL Server databases and application to the 2008 R2 Failover
cluster. Conduct Risk and Health Assessment Program for Cluster Server
(CSRAP)
Upgraded SQL Server 2005 mirroring server to SQL Server 2008 mirroring
server to up to date for database mirroring.
Developed SQL Server Enterprise design document
Supported migration of Oracle 10g databases and application to Oracle 11g
I also have technical experience relevant to this particular contract
regarding the following databases, operating systems, office programs,
reporting tools, SQL server tools, web servers, and languages: OEM, RMAN,
RAC, TOAD, FLASHBACK, BACKUP AND RECOVERY, PARTITIONING ADDM, AWR,
DATAGUARD. SSIS, SSRS, MS SQL Server, Enterprise Manager, Profiler, Query
Analyzer, Export & Import, (DTS) PostgreSQL, MS SQL Server Reporting
Services, application development, data modeling, Crystal Reports,
SharePoint Server, MS SQL Server 2008 R2 enterprise, 2008 standard,
2005/2000/7.0/6.5, T-SQL, SQL, and PL/SQL.
CERTIFICATIONS
Certified Microsoft office User
Master Certificate Oracle 10g DBA
EDUCATION
Bachelor of Science in Computer Science, University of Benin
Master Certificate Oracle 10g
EXPERIENCE
SRA International (USGAO)
Senior Database Administrator 03/2011-Current
( SQL Server and Oracle)
. Provide primary lead support for the GAO SQL Server, MYSQL
environments and support GAO Oracle environment.
. Support quarterly consolidated reporting for the GAO Oracle and SQL
Server environments
. Database Operations Support
. SQL Server database migration and upgrade
. Oracle database migration to 11g
. On-Call Support
. Physical Database Design
. Physical Database Implementation
. Database Inventory
. Security and Access Standards
. SQL Server failover clustering
. Database Backup and Recovery
. Continuity of Operations
. Database Monitoring
. Database Notification
. Database Maintenance
. Critical Patch Updates
. Database Change Management
. Database Password Maintenance
PAE, A Lockheed Martin Company
Senior SQL Sever Database Administrator and Configuration Manager
09/2010 - 02/2011
. Resolve database performance and capacity issues
. Design, Schedule, Implement, and perform regular database backup and
maintenance
. procedures.
. Provide database design assistance for the development of custom
applications.
. Utilize SQL experience to provide adhoc reports to respond to
immediate business needs
. Use existing reporting applications to deliver standard reports for
global consumption
. Implementing business needs using business intelligence design studio
(BIDS)
. Ensure all scripts for the entire database are in a source control.
. Develop operational procedures.
. Move new database designs toward an Enterprise Data Management
Solution
. Other duties as assigned.
National Institute of Health Training Center (WSDD)
SQL Server DBA/ LMS Project Administrator 04/2010
- 08/2010
. As a SQL Server DBA he supported remote production and development
servers, clustered/non clustered environment.
. Update user records, update employee profiles, add vendors, update
vendors, process de-obligations (refunds) etc.
. Use SQL Query Analyzer to update or create.
. Performed DBMS maintenance, backup and recovery.
. Implemented, configured, administered replication and log shipping.
. Designed Report in SQL Server Reporting Services and used Reporting
Services to search for the SQL Server Log.
. Conduct performance monitoring and tuning, implemented performance
improvements of database instance/environment.
United States Patent and Trademark Office
Senior Oracle 10g Database Administrator
03/2005- 03/2010
. Responsible for, both manage and support all Production, Development
and Staging instances of Oracle Version 10g.
. Maintaining data integrity and tune database for optimum performance
and availability.
. Ensuring successful & periodical Backup, Restoration & Tuning.
. Backup and recovery using RMAN, change management, Data Modelling,
scripts for various database activities, troubleshooting etc.
. Install and administer Oracle Products.
. Provide technical support and assistance to all database end-users.
. Install new versions of database software and perform maintenance
functions of the database.
. Upgrading of Database from lower version to higher version.
. Installation of Patch.
. Monitor usage of the databases and perform database tuning using
Explain Plan, hints, utlbstat/utlestat, Toad, PowerExplain, and
Enterprise Manager.
. Plan for system growth and monitor capacity usage for new hardware or
software requirements and communicate these capacity requirements to
management.
. 650 databases in 400+ servers (windows, Linux & Unix) more than
~5000GB of DB size.
. Create new Database,perform regular backup's for all the database
and main the DB's
. Provided 24x7 on call production support.
. Created materialized views.
Mobil Communications, SQL Server Database Administrator 2/2002-
2/2005
. Designed and developed various reports on Excel Spread Sheet through
ODBC, Access database
. Performed DBA related responsibilities, repairing and maintenance.
. Administered SharePoint server by updating meeting information/agenda,
creating new users on SharePoint.
. Provided support to users during process. Prioritized jobs on
Mainframe.
. Controlled, Monitor and maintain production quality.
. Distributed listing, reports, media files, electronic mail, voice mail
and complete schedules as required.
. Updated user records, update employee profiles, add vendors, update
vendors, process de-obligations (refunds) etc. The tables that I'm in
the most are in that database document.
. Used SQL Query Analyzer to update or create. As a SQL Server DBA he
supported remote production and development servers, clustered/non
clustered environment. Performed DBMS maintenance, backup and
recovery.
. Implemented, configured, administered replication and log shipping.
Designed Report in SQL Server Reporting Services and used Reporting
Services to search for the SQL Server Log.
. I also conducted performance monitoring and tuning, implemented
performance improvements of database instance/environment.
MS Access, Excel, SQL, Windows 2000
Contact this candidate