Sql Server Database Administrator
Resume:
William Hagan
Sr. Oracle/SQL Server Database Administrator
Phone: 563-***-****) ● Email: **********@*****.***
EDUCATION:
BS. Computer Science - Kwame Nkrumah University of Science & Technology
2004 - 2008
Oracle Certified Associate
Delphix Certified
SUMMARY OF QUALIFICATIONS
Seeking an opportunity in a stable company to further my expertise and skills as a Sr. Database Administrator.
Extensive Experience in Oracle database, SQL Server, and Delphix Virtualization/Continues Compliance Data Masking.
I am a self-starter, self-motivated and work very efficiently in stressful situations where speed and accuracy are necessary in a mission critical 24/7 environment.
• 20 years as an IT professional and 16 years plus of experience in the field of Database Technology in an Enterprise environment with extensive knowledge and experience in Oracle 9i, 10g,11g, 12c, 18c, 19c, MS SQL Server, Delphix Virtualization/Continues Compliance in a designing, developing, testing and Production environments.
• Experience as On-Call 24x7 production DBA support and application/development DBA.
• Experience translating business requirements into conceptual, logical, and physical data models.
• Extensive experience in Oracle High Availability (HA) Services installation, administration and troubleshooting, Grid Management, Data Guard (Oracle Active Data guard), Real Application Clusters (RAC), Fine Grain Auditing (FGA).
• Experience in Delphix Virtualization, creating Data Sources for both Oracle and SQL Server and Provisioning and managing VDB’s.
• Experience in Designing and using Delphix Continues Compliance to profile user Data to determine PII and masking the data in lower environments for all databases.
• Experience with multi-tenant architecture (Container and Pluggable databases) including Cloud databases and Exadata Cloud Databases.
• Extensive experience with deploying targets, monitoring, and administration in Oracle Enterprise Manager (OEM) 12c and 13c.
• Experience in configuring Oracle network, RMAN, Recovery Catalog and Performance Tuning of Database by optimizing SQL and PL/SQL scripts using the Explain Plan, SQL Tuning Advisor and SQL Plan Management. Used stats pack report, AWR report, ADDM advisors, to tune instance and entire system.
• Management and implementation of database models, data flow diagram, database schemas, database scripts, to support a robust data management infrastructure.
• Experience in metadata definition, implementation and maintenance, new business rules identification and implementation to data rules, transformation.
• Experience is user management including creating users, roles, profiles, and resource management.
• Experience with defining triggers events, cursors, stored procedures, and packages.
• Created and executed SHELL SCRIPTS to automate RMAN backups, file system cleanup and monitoring.
• Extensive experience in database cloning using RMAN duplicate.
• Standard Database Administration tasks include automated installation, creation and replication of databases, management of tablespaces, logs, grants, roles, users, indices.
• Working knowledge of SQL Server migrations to Microsoft Azure.
• Working experience in database cloning, data warehouse, database backup and recovery procedures and security.
• Experience in migration using, SQL Loader, Data pump, and transportable Tablespaces.
• Experience with Oracle Transparent Data Encryption (TDE).
• Experience managing Oracle Cloud databases (DBaaS) and Exadata databases.
• Extensive experience in working with Oracle Support in troubleshooting database and Application related issues.
TECHINICAL SKILLS:
RDBMS: - Oracle 9i, 10g and 11gr2,12c,18c,19c - Microsoft SQL Server 2008r2,2012,2014, 2016 and 2019.
Applications: OEM 13c, Delphix Continues Compliance 9.0.0.1, Delphix Continues Compliance (Data Masking).
Database Tools: - OEM 13c, SQL*PLUS, SQL*LOADER, DBCA, RMAN, Data pump, Oracle Cloud Database (DBaaS), Exadata databases, AWR, ADDM, DBUA, SQL Tuning Advisor, OUI, Oracle Net Manager, Oracle Forms, TOAD, WINSCP, Putty, Exceed, Beyond Compare, OPatch, SSRS, TSQL, Delphix, Rubric, Qlik/Attunity Replication.
Operating Systems: - Oracle Linux 5/6/7, Remote Tools Cisco VPN, Checkpoint VPN, VNC, RDP, VMware Virtualization, Microsoft Server 2012.
Certifications:
Oracle 11g Certified Database Administrator Associate OCA - 2013
EDUCATION:
BS. Computer Science - Kwame Nkrumah University of Science & Technology
2004 - 2008
WORK EXPERIENCE
Morgan Stanley - Remote
Dec 2021 to Dec 2023
Role: Sr. Oracle/SQL Server Database Engineer SME
• Lead, designed and worked with the sysadmins, storage, network, and Infrastructure teams to migrate all Oracle and SQL Server databases from Eaton Vance to Morgan Stanley Data Center.
• Re-evaluate and configured Our Delphix Virtualization Engine by adding more resources as capacity planning for upcoming Virtual Databases.
• Provide support and leadership on all Enterprise databases including Oracle and SQL Server from database sizes ranging from 40G to 21TB.
• Designed and built Data Guard Physical standby databases for all our Production databases in the cloud and managed them with the Data Guard broker and OEM.
• Configured Oracle Active data guard for our Enterprise Data Warehouse database to allow read and write for our Business Intelligence reporting and other Applications.
• Configured database backups to run on the standby databases to enhance performance on our OLTP Primary databases.
• Created Data Sources and provisioned both oracle and SQL Server virtual databases for users as needed.
• Assisted with SQL Server upgrades from versions 2016 to 2019.
• Assisted and created SQL Server Transactional and Bulk replication tasks using Qlik attunity replication tool.
• Installed and configured 2 Node SQL Server Always on for High availability.
• Used SQL Server performance tuning tools sp_whoisactve to identify expensive queries and blocking sessions to optimize performance.
• Assisted Developers with query optimization by recommending best practices for writing queries, creating and maintaining Clustered and Non-Clustered Indexes for better performance.
• Assisted with scheduled and adhoc database refreshes and needed for Users.
• Assisted in database monitoring with Idera tool and configuring Full and Transaction Log backups using Rubrik as the backup tool.
• Performed SQL Server object shrink operations to re-claim space in the OS level.
• Assisted with User login and access issues through our Cherwell ticketing system.
• Worked with Application Team to integrate Delphix with our logging Application Splunk.
• Worked with Network Security team to create Certificates and enabled SSL for Our Delphix Engine.
• Worked with Project Manager and Team Mates to develop a plan to Mask all Customer Personal Identifiable Information (PII) in all lower databases Environments.
• Used Delphix Continues Compliance Engine to Profile data in UAT and DEV databases for PII and created a Masking Job to mask tables with PII.
• Assisted databases users with their connections and user accounts and provided education on database technology.
• Participated in a 24/7 call rotation as needed.
• Assumed the role as a Subject Matter Expert (SME) for both Oracle and Delphix Administration.
• Provided project updates and progress to the Executives and Database Manager.
• Assisted in day-to-day database support using Kanban for Projects and Cherwell as our ticketing tool.
• Continuously investigate new technologies and acquire necessary knowledge to enhance the optimization of all Enterprise databases.
• Participate in knowledge transfer and continues training of fellow DBA’s and Users on latest technologies.
• Ensured compliance with the company Compliance Policies as documented.
• Maintained an updated SOP and other documentation as needed to enhance standard databases operations and support.
Eaton Vance - Remote
Marc 2021 to April 2022
Role: Sr. Oracle / SQL Server Database/ Delphix Administrator SME
• Lead, designed and worked with the sysadmins, storage, network, and Infrastructure teams to migrate all Oracle databases from On Prem database to Oracle on AWS VMC.
• Configured Oracle Data Guard Physical Standby in Maximum Performance mode on AWS VMC for our Standby databases during the migration.
• Create data guard broker to manage data guard configuration.
• Documented my steps on the Data guard configuration and shared with team members for upcoming Builds.
• Delphix Virtualization Administration by creating and managing Data Source, Virtual Databases VDB’s for our developers and Application owners for their development and QA testing.
• Provide support and leadership on all Enterprise databases including Oracle and SQL Server from database sizes ranging from 20G to 14TB.
• Designed and built OEM 13.4.0.0.0, applied patches, and deployed all the agents on all Oracle targets.
• Configurated monitoring templates, incident rules and alert notification through email and SMS text messages.
• Designed and built Oracle databases 18c and 19c RAC and ASM Grid Infrastructure on oracle Linux 7 on VMC.
• Assisted Application owners and developers to migrate their Applications to VMC.
• Created Oracle backup policies and schedules using Rubric and Crontab according to our SLA’s.
• Assisted databases users with their connections and user accounts and provided education on database technology.
• Participated in a 24/7 call rotation as needed.
• Assumed the role as a Subject Matter Expert (SME) for both our Oracle and SQL Server databases.
• Provided project updates and progress to the Executives and Database Manager.
• Assisted in day-to-day database support using Kanban for Projects and Cherwell as our ticketing tool.
• Ensured we planned and installed oracle and SQL Server Security Patches to ensure compliance and up to date on all required security updates.
• Continuously investigate new technologies and acquire necessary knowledge to enhance the optimization of all Enterprise databases.
• Participate in knowledge transfer and continues training of fellow DBA’s and Users on latest technologies.
• Ensured compliance with the company Compliance Policies as documented.
• Maintained an updated SOP and other documentation as needed to enhance standard databases operations and support.
HNI Corporation – Muscatine Iowa
July 2015 to June 2020
Role: Sr. Oracle/SQL Server Application Database Administrator
• Worked daily with Development, Infrastructure Engineering team and management in an Enterprise Environment to design, build and support Database Management systems and Applications to satisfy end users and business needs.
• Provided documentation and supervised Tier 1 & 2 offshore DBAs for afterhours support and Maintenance.
• Provided 24x7 Production database and applications support.
• Used Imperva WAF as a third-party tool to secure our Legacy Oracle 9i databases.
• Imperva agents were installed on Oracle 9i database servers on AIX by the infrastructure team to protect our legacy 9i databases since it was out of support and didn’t have any available Oracle Security patches.
• Applied quarterly Oracle/SQL Server Security patches to databases, Middleware/WebLogic and other Applications as released.
• Worked with team and OCS to migrate Oracle database and Applications using RMAN Cloning and Oracle Data pump from on prem to Oracle Cloud infrastructure (OCI) and Oracle EXADATA.
• Designed and built Data Guard Physical standby databases for all our Production databases in the cloud and managed them with the Data Guard broker and OEM.
• I built an Active Data guard for our EBS and Data warehouse databases to offload long running and resource intensive queries for BI Publisher reporting, backups, and daily clones.
• I recently upgraded our OEM from 12c to 13c, applied all OMS available patches and upgraded all target agents as needed.
• Designed, installed, and built multiple Oracle RAC 3 Node and 2 Node Cluster databases with ASM storage and configuring TAF for Transparent Application and session failover during a Node crash or eviction.
• The team and I set up monitoring for all our oracle databases, applications, and Middleware in OEM to send notifications when thresholds were exceeded.
• Tested database and Application changes in Development through UAT and submitted change request to Change Management (CM) for approval to push it to Production.
• Participated in User Management, creating new users adding their account to the appropriate roles and profiles.
• Worked on customer tickets and created Change requests using Cherwell to meet SLA’s.
• Created detailed documentation and SOP of tasks and uploaded to the SharePoint site for team members to use as reference.
• Configured Database backups for Cloud and Exadata databases through the console and from the backend. Created customized Shell Scripts and placed them in the cron tab for the backups to be taken at a scheduled time.
• Worked with Sysadmins to configure backup scripts policies for our Oracle and SQL Server databases using NetBackup.
• Create multiple pluggable databases for in Container databases provisioned in BaaS or Exadata cloud.
• Administered and managed Transparent Data Encryption (TDE) and Wallet management.
• Worked with the Solution Architects and Development team to push Code changes into Production after appropriate tests and Change Management Approval.
• Worked extensively with team mates to troubleshoot performance issues using tools like OEM, Toad, AWR reports, ADDM, SQL Tuning advisor.
• Created, managed, and pinned SQL Profiles to queries with expensive execution plans for optimal performance.
• Experience working with Internal Audit team and SOX Audit by providing requested audit documents through Oracle GRC.
• Transferred Knowledge to team mates on self-study technologies and skills needed for day-to-day database and application support.
• Supported and applied patches to Oracle Identity Management Application (IDM) Including OIM, OAM and OID.
• Designed and built a 2 Node OBIEE /BI Publisher 12c, DAC 11g and Informatica 10.2 as part of upgrade from 11g to 12c.
• Used bi-migration-tool.jar tool to migrate metadata from 11g home to 12c environment as part of the upgrade.
• Provided day to day support of OBIEE, Informatica and DAC including migration of changes from changes from UAT to prod and resolving performance issues.
• Worked closely and extensively with Oracle support to investigate and resolve bug, functionality or performance related issues including One off patch.
• Helped migrate data and creation of database on AWS system for applications.
• Assisted in migrating some SQL Server databases from On-prem to Azure Cloud Services.
• Assisted developers and other users on databases technologies.
Micro Electronics Inc. - Rockville Maryland
May 2008 to July 2015
Role: Oracle / SQL Server Database Administrator
Oracle Experience:
• Worked closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment and evaluation.
• Performed oracle server software installation using the OUI, database creation using the DBCA, system configurations and upgrades.
• Documentation of all configurations, installations, implementations, monitoring, and testing projects for future utilization.
• Supported a 24/7 environment on a Linux Red hat Platform from Development, Testing and Production environments with database sizes ranging from 4GB to 2TB.
• Successfully Cloned, /Migrated Data using RMAN and Data pump Export/Import utilities.
• Manage, tune, and troubleshoot database issues both on UNIX and LINUX command line, SQL*Plus, OEM client, Oracle 11g database control, oracle 11g Grid Control as well as other third-party tools.
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using OEM/ Oracle 11g database control & SQL*Plus.
• Troubleshoot errors with team members, independently and with Oracle support (via oracle Support)
• Application of quarterly Oracle software patch set updates (PSU) when/where necessary using the OPatch utility.
• Backup/Recovery monitoring and reporting using both BMC SQL Backtrack Oracle RMAN and implemented recovery strategies whenever required for successful database recovery in case of a database crash, media/disk failures by using RMAN. Also scheduled the Incremental backups using RMAN utility and using Database Control to monitor job.
• Create database Objects, Table spaces, Schemas as needed.
• Implementation, administration and troubleshoot of Oracle ASM instances.
• Monitoring database with Database control and used SQL TRACE, EXPLAIN PLAN, SQL Tuning Advisor to optimize high load SQL statements.
• Used the oracle SQL PLAN Management to create SQL Profiles to assist the CBO come up with the best execution plan and then create a SQL PLAN Baseline to tune resource consuming queries.
• Used the AWR and ADDM for Statistics management and database tuning following the creation of new databases and periodically thereafter.
Microsoft SQL Server Experience:
• Worked with network manager, system engineer/admins, programmers, and Web developers to install and upgrade existing MSSQL Servers from version 2005 to 2008r2.
• Created logins and service accounts using the wizards and granting appropriate user permissions on objects in the databases per business rules.
• Created synonyms on Development Server pointing to Production database for developers to use for reporting.
• Used the Maintenance plan wizard to automate jobs such as Transaction log clean up and shrinking and taking backups of both Production and Non -production databases.
• Set up a Transactional Replication with updatable subscriptions creating a Linked server in the process using our Development and Test environment as Publishers and the Webserver and the Subscriber.
• Used the Replication monitor to monitor replication between servers and used the database mail to create email alerts in an event of Log agent latency or failure.
• Exported databases between servers using the import export wizards.
• Created reports using the MSBI visual studio SSRS utility using oracle as my data source and deployed it to the Report server for reporting there afterwards.
• Implemented SQL Server optimization by using the SQL Profiler and SQL Analyzer to capture resource intensive SQL Statements and created Clustered or None- clustered indexes per the recommendation of the SQL Analyzer.
• Created Linked servers on SQL Server to be able to query data in Oracle database.
Certifications:
Oracle 11g Certified Database Administrator Associate OCA - 2013
EDUCATION:
BS. Computer Science - Kwame Nkrumah University of Science & Technology
2004 - 2008
Contact this candidate