SUMMARY

• Comprehensive experience in high level strategic planning and advanced systems architecture, including full project management life cycle, team leadership, Datacenter migration with specific focus in high availability, performance tuning and security compliance in enterprise database environments.
• Was remote working from home for years prior to COVID - 19 using tools such as Skype, Zoom, VPN, Sonic, vSphere, Hipchat, and MS Teams.

PROFESSIONAL EXPERIENCE

Confidential, Hermitage, TN

Environment: Confidential 10g, 11g, 12.1, 12.2 Standard and Enterprise Edition, AIX, Unix, Linux, OEM 12/13 GRID, GRID, ASM, Skype, SSH, Delphix, largest database supported 2.5 TB

Responsibilities:

• Served as a member of the production Confidential DBA team Planned, tested, scheduled, and upgraded Confidential database systems from 11g to 12.1, 12.1 to 12.2/18c
• Perform database builds, system refreshes, user account enrollments, database restores,
• Plan, schedule and apply quarterly Confidential PSU’s and RU’s throughout landscape
• Scope, plan and build database systems
• Participated in on call rotation in our 24/7 database system
• Responsible for all aspects of database administration for Confidential databases, including problem-solving, configuration, and implementation efforts for large and/or complex projects with an emphasis in operational excellence and continuous improvement of database related processes and procedures.
• Planned, documented procedures, and coordinated database activities with local and remote team members and customers including team members and customers in India.
• Flexiblity to work in a dynamic fast paced environment with rapid technology changes and complex customer demands. Involved with other technologies that interface with the database, such as, but not limited to Confidential SQL*NET, Confidential Management Server, Quest TOAD, and Shell Scripting
• Planned and configured Confidential databases on a Delphix platform for ease of database refreshes in lower environments
• Ability to effectively communicate to all levels within the organization as well as directly with customers on new projects and / or issues with production systems
• Develop standards, processes, and procedures within the scope of Platforms and Storages DB Services Confidential team

Confidential, Nashville, TN

Environment: Confidential 10g, 11g, 12.1 Standard and Enterprise Edition, Linux RedHat RHEL 5/6 64-bit, SQL Server 2008, Windows 2008, Confidential RACOEM 12c, GRID, ASM, Skype, SSH, Mac, AWS

Responsibilities:

• Serving as a team member of the database administrator’s group DBAAS
• Build RAC node databases in AWS environment
• Develop schema build scripts for implementation of healthcare information exchange participants.
• Developed and deploy scripts for tablespace usage alert notifications to Pager Duty.
• Participate in other teams project work requiring DBA’s assistance.
• Perform database migrations from old servers to new servers across production, stage, test, and development environments using Data Pump
• Provide oversight of and recommendations on database administration leading practices.
• Provide advice, recommendations and design decisions;
• Planned and implemented backup and recovery using RMAN
• Generated and analyzed AWR reports for performance
• Used SQLLDR to perform data loading
• Participate in scaling, capacity planning and sizing activities to define the appropriate hardware and software to meet requirements.
• Participate in 24/7 on-call rotation.

Confidential, Nashville, TN

Environment: Horizon v9, v11, Nugenesis v9, Confidential 10g and 11g, SQL Server, 2005, SQL Server 2008, 2012 clusters, Cache DB, Windows 2003 ServerWindows 2008 Server, Data Guard, Golden Gate

Responsibilities:

• Served as production DBA for Confidential, SQL Server, Cache DB, and Progress databases.
• Performed daily database administration and monitoring, upgrade planning, upgraded databases, database builds, and deployments.
• Generated AWR and ADDM reports for performance tuning application code
• Setup RMAN backups
• Performed system refreshes of lower environments using RMAN
• Setup Data Guard environments for high availability of lab database systems
• Used Confidential data pump to move data upon customer requests
• Examined and modified database maintenance plans for Confidential and SQL Server (transaction log backups, daily and weekly backups),
• Enlisting database user accounts for both Confidential and SQL Server databases
• Documented system checks for all database systems
• Applied Confidential quarterly security PSU’S, CPU’s AND RU’s, Microsoft SP’s, and CU’s.
• Duties also included starting and stopping HL7 background processes via request

Confidential

Environment: SAP R/3-ECC 6.0, GRC 5.3, Solution Manager 4.0, SRMBW/BI, XI/PI, Portal, Confidential 10G

Responsibilities:

• Supplied Confidential 10g to 11g upgrade technical direction to on site Confidential DBA at Newmont Mining Confidential based in Denver, CO in a SAP shop (before Go-Live).
• Met with stakeholders to understand business requirements and translate the requirements into working project plan
• Collaborated with hardware team, Basis leads and project managers to plan scheduled outages and identify key personnel needed for the purpose of the upgrade.
• Developed and delivered Confidential 10g to 11g upgrade project and documentation.

Confidential, Baltimore, MD

Environment: SAP R/3-ECC 6.0, GRC 5.3, Solution Manager 4.0, SRMBW/BI, XI/PI, Portal, Confidential 9i/10G

Responsibilities:

• Planned, installed, tested, implemented, administered, and maintained physicians clinics patient care GE Centricity server side software product and backend Confidential database as the productionConfidential DBA.
• Provided production support for SQL LIMS backend Confidential database at Center for Inherited Diseases Research Laboratory
• Planned database server hardware upgrade installing and patching Confidential . Provided daily administration and performance tuning of back-end Confidential databases serving front end SunOne LDAP directory enterprise wide authentication application.
• Met with stakeholders to plan regularly scheduled demographic data feeds and distribute data load requirements according to the designed data dictionary
• Developed bulk data loading scripts of user demographic data from disparate data sources. using Korn Shell and sqlldr scripts, PL/SQL triggers, and PL/SQL code
• Provided ongoing process improvement of data loads to protect against deleting users from the directory and enforcing business rules via integrity constraints.
• Responsible for site licensing compliance and support maintenance.
• Developed statement of work orders for short, interim, and long term department goals.
• Supplied SQL Server database administration in support of clinical patient order entry systems.
• Planned, developed documentation and held classroom cross sessions on Confidential support and administration to staff of SQL Server and DB2 database administrators, servicing clinical hospital and higher customer base.
• Provided 24/7 on call support for SQL Server and Confidential .

Confidential

Environment: Confidential 10G, Confidential versions 6-18c, Confidential Forms and Reports 11g/12c, OEM 13, GRID, OEM Fusion Middleware, Linux, SAP R/3-ECC 6.0, GRC 5.3, Solution, Manager 4.0, SRM, BW/BI, XI/PI, Portal

Responsibilities:

• Troubleshoot and fix recently migrated to off premises Confidential Forms and Reports servers to a functioning state. Make configuration and script changes as deemed necessary. Assure client is able to access reports on off premise servers
• Provided SAP Basis Administration support to project teams, creating user accounts, performing transports, and system refreshes.

Confidential, Columbia, MD

Environment: Windows 2000, Confidential 8i

Responsibilities:

• Provided production and development Confidential DBA support.
• Installed and configured 6 Confidential 8i servers for Windows 2000 along with 2 remote JAVA based clients for network security software product serving as the front end application.
• Performance tuning databases and PL/SQL for optimal functionality.
• Coordinated application UAT with functional team.
• Executed and documented explain plans using Statspack to make index and hint recommendations based upon UAT results.
• Monitored and maintained chained rows, indexes, and wrote scripts to control volumes of archive logs, resizing log files based upon alert log entries and level of transactions. Resolved mutating table issues.
• Performed Confidential upgrades and applied patches.
• Planned, developed batch scripts for routine schedule database backups and met with hardware staff to coordinate time table to run backups based upon full scope of OS scheduled maintenance.
• Provided bulk data loading solution utilizing temp load tables, SQL Loader, insert and update triggers to load master table and audit log tables.
• Monitored tablespaces, resizing, moving or adding datafiles when needed.
• Maintained consistency between dev, test and production databases depending on development needs. Skilled in meeting deadlines, deliverables and can work under pressure.

Confidential, Columbia, MD

Environment: Confidential 8i, 9iAS, Discovered Reports, UNIX

Responsibilities:

• Designed and re-engineered new and existing web based Discoverer reports based upon customer specifications.
• Project consisted of tracking federal, state, and local government officials terrorist attack readiness.
• Performed Confidential 8i and 9iAS database product installation of Portal, Discoverer, Reports, Forms. Implemented Discoverer row level security using database views, functions, privileges, and roles.
• Skilled in meeting deadlines and deliverables.

Confidential, Baltimore, MD

Environment: Confidential 8i, SUN Solaris, Discovered Reports, UNIX

Responsibilities:

• Installed and configured Confidential 8i Enterprise Server on Solaris 5.2. Planned and implemented database backup and recovery.
• Performed Confidential upgrades and applied patches.
• Responsible for implementing process for the gathering of business requirements and work with Data Administrator of legacy systems to transition new database design from logical to physical implementation.
• Analyzing source systems data across all business areas in an effort to join desperate systems into one relational database; Payroll/Human Resources - hospital/University, Student Registration, Alumni, Library Resources, Email etc.
• Used Erwin ERD tool to perform data modeling. Standardized methods of data feed file formats, file transmission scheduled cronjobs for automation of workflow process.
• Performed bulk data loads utilizing SQL Loader.
• Simultaneously monitored and performed adhoc maintenance when necessary during bulk loads in following database areas; chained rows, growing extents, extending datafiles, and fragmenting tablespaces.
• Developed database stored procedures and triggers to enforce business rules and data auditing.
• Wrote final staging scripts of UTL file exports of data according to spec's derived from LDAP directory requirements. Integrated Confidential and Cold Fusion server.
• Skilled in meeting deadlines and deliverables.

Confidential, Baltimore, MD

Environment: Windows NT, MS SQL Server 7, Confidential 8i, Crystal Reports

• Managed reports development personnel for AmericasDoctor.com
• Planned database re-design and web server migration from MS SQL Server 7/NT to Confidential /Sun Solaris.
• Effectively and efficiently gathered report specification from company CEO and president, transforming verbal and written report request into tangible figures, formatted reports meeting tight deadlines.

Confidential, Herdon, VA

Environment: Confidential 7.3.4, SUN Solaris, Shareplex

Responsibilities:

• Provided on-site Confidential DBA support in production and development Confidential backend databases for an inventory management system (Tivoli) and trouble ticketing system (Service Center) at the IRS.
• Implemented disaster recovery plans; configuring alternate server as a mirror of production database. Assisted in writing scripts to ship redo and archive logs to mirrored server.
• Tuned database fragmentation growing extents using exp/imp method.
• Resized datafiles, running scripts or line mode row clearing of lost chains.
• Assist in requirements gathering for stored procedure and update triggers. Examined developers PL/SQL procedures prior to production deployment. Recreated databases, via modifying create database scripts.
• Performance monitoring of buffer cache and performance tuned parallel query tweaking max dump file Confidential parameter.
• Performed full database recovery due to removal of directory containing database files
• Cross trained as backup Unix systems administrator on Sun and Linux servers.
• Gained experience in setting up printers, assigning user id’s, killing print jobs and logins, and setting system monitoring options. Developed scripts to perform record inserts for various file types; tab delimited, comma, piped or creating a temp table from source table using a correlated insert query or update method.
• Prepared source and destination servers for Shareplex database replication and report server implementation.

Confidential, Largo, MD

Environment: Systems Analysis and Design

Responsibilities:

• Analyzed existing pilot relational database system using Case Tools modeling methodologies in preparation of move to production as a deliverable to the government.
• Identified areas requiring further development regarding referential integrity and data validation.

Confidential, Lanham, MD

Environment: Windows NT 4.0, Confidential 7.3.2, FoxPro, Application Extender, Disk Extender

Responsibilities:

• Assisted the Navy in DoD downsizing and paperless initiatives.
• Leveraged Application Extender for migrating contract documents to electronic form. Devised innovative production process for massive electronic data file imports of ASCII, OLE and Video/ sound recordings datasources and file types.
• Employed integration tools such as SuperTCP, MS TCPIP, ODBC utilities, SQLNET V2.2., and configured TNSNAMES client files.
• Provided front/back end systems administration; setup data sources, created and assigned user accounts, implemented security according to departmental requirements.
• Coordinated, developed, and delivered manuals for user sessions
• Setup on-site user facility and delivered classroom instruction to both east/west coast DOD and civilian personnel. Performed Confidential 7.2 to Confidential 7.3.2 client/server Enterprise Manager for NT upgrade
• Traveled to San Diego to perform data migration of 110GB of FoxPro 2.5 production data to Confidential 7.3.2 production database
• Designed, created, and modified database tables as needed to accommodate data needs.
• Performance tuned the database to enhance database migrations; increased shared pool size and processes values.
• Engineered production process for massive electronic data file imports having the following file types: ASCII, OLE and Video/ sound recordings.
• Managed and maintained 150GB Raidion storage device, controller and peripherals. Performed recovery due to failed devices: swapping out failed 9GB hard dives and restoring data from tape backups.
• Integrated imaging front-end system and Confidential client into a 300 node Novell 4.1/ Windows NT LAN/WAN infrastructure having desktop setups of WFW, Windows 3.1 and eventually CDI standardized Windows NT 4.0 desktop and setup RAS connectivity.
• Worked with hardware team to develop, implement and schedule backups of database.
• Worked with hardware to devise plans to deliver hardware to the new destination, restore server content and UAT cycles; wrote winstall scripts, established shipping and delivery date, packed, and shipped the system from Arlington to San Diego.
• Deployed system as planned, in San Diego; Maintained ongoing relationships with vendors for additional hardware and software purchases of hard drive spares for future upgrades.
• Established a good working relationship with DOD clients at all levels. Generated white paper for Confidential database replication services.
• Provided weekly status reports to the DOD and daily status reports to corporate.