Senior Database Administrator Resume

SUMMARY:

Senior database administrator with experience in distributed enterprise OLTP and big - data replicated environments
Designed and implementing production-grade high availability fast-start fail-over clusters
Managed multi-platform 24x7 high-availability, terabyte scale database applications environments, serving content management, authentication, PCI compliant electronic commerce, and warehouse systems
Designed, and deployed systems, establishing on-going support requirements for sizing, growth predictions, replication requirements, backup and recovery, data load, ETL, and routine maintenance
Experience working both independently or in a collaborative team environment with internal customer groups and strategic partners
Worked with developers to review their SQL scripts identifying potential performance issues, workload bottlenecks; tuning indexes and recommended logical architectures
Used Best Practices in establishing security roles and creating procedures for file system layout, configuration management, and failure recovery processes
Conducted root-cause analysis
Developed logical data models and associated DDL, DML for schema updates and as part of Disaster Recovery capability.
Used Data Guard replication processes to conduct system cloning, migration, and providing fast-failover capability for disaster recovery and business continuance
Utilized Data Pump and Flashback for bulk data transfers and operational integrity. Materialized views to push data changes to slave systems.
Reviewed and released Oracle security and bug fix updates as required
Implemented Oracle GRID 12c to monitor and manage 80+ instances, providing longitudinal measures of system performance, storage capacity, growth rates, server workload, transaction rate performance, backup and HA data guard status. Detected errors were forwarded to the scheduled on-call personnel by email and pager.
Wrote documentation and application notes using collaboration tools such a Confluence and Jira
Used profiling tools to assess SQL performance and analyze potential improvements
Wrote shell and SQL scripts to automate multiple support tasks including from backups, query monitoring, performance metrics and routine audit processes

TECHNICAL SKILLS:

OS Environments: Unix (AIX, Linux, HP/UX), AWS EC2, OVM (Oracle Virtual Machine), Windows

Databases: Oracle (10g, 11g, 12c), PostgreSQL (9, 10), Teradata, MS SQL Services (2016)

Support and Collaboration Applications: Vertex, Kronos, Confluence, Jira, Service Now, Pager Duty, CVS, Git

Tools: OEM, GRID Cloud Control, SQL Developer, Data Guard, RMan, Data Pump, AWR, Perfstat, Flashback, ASM, OMF

Languages: SQLPlus, PL/SQL, Python (2x/3x), R, Numpy, Scipy, Matplotlib, Scikit-Learn

Utilities: Shell scripting (Bash, Korn), Anaconda, Jupyter

EXPERIENCE:

Confidential

Senior Database Administrator

Confidential

Senior Operations Manager

Confidential

Consulting Database Administrator

Confidential

Database Administrator

Responsibilities:

Developed corporate SOX and security audits of SOX, PII and PCI data to management teams on a quarterly and annual basis
Designed secure, token-based PCI (credit card) database layer for electronic commerce operations supporting eight million active customers and approximately 160 million transactions annually; successfully passing five consecutive external audits
Experience working both independently or in a collaborative team environment with internal customer groups and strategic partners
Worked with developers to review their SQL scripts identifying potential performance issues, workload bottlenecks; tuning indexes and recommended logical architectures
Used Best Practices in establishing security roles and creating procedures for file system layout, configuration management, and failure recovery processes
Conducted root-cause analysis
Developed logical data models and associated DDL, DML for schema updates and as part of Disaster Recovery capability.
Used Data Guard replication processes to conduct system cloning, migration, and providing fast-failover capability for disaster recovery and business continuance
Utilized Data Pump and Flashback for bulk data transfers and operational integrity. Materialized views to push data changes to slave systems.
Reviewed and released Oracle security and bug fix updates as required
Implemented Oracle GRID 12c to monitor and manage 80+ instances, providing longitudinal measures of system performance, storage capacity, growth rates, server workload, transaction rate performance, backup and HA data guard status. Detected errors were forwarded to the scheduled on-call personnel by email and pager.
Wrote documentation and application notes using collaboration tools such a Confluence and Jira
Used profiling tools to assess SQL performance and analyze potential improvements

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship