Senior Oracle Database Administrator Resume Dallas, TX - Hire IT People

SUMMARY:

Over 10 years of experience as an Oracle DBA at Confidential
Support 2000+ Oracle database systems and ensure they operate at their optimum
Create and implement complete life cycle servers and databases from development to production/disaster recovery in an ‘Agile’ environment model
Collaborate with Project Managers, SAs, Network team, GNOC, application developers, priority issues, and root cause analysis
Implement security, audit, and backup/restore procedures to ensure database integrity
Facilitate numerous sustainable resilience tests like switchover, failovers, HADR environments
Superior analytical and problem solving skills, communication, presentation

TECHNICAL SKILLS:

Databases: Oracle 9i, 10g, 11g, 12c

Platform OS: Unix, RHEL 5/6, IBM - AIX 5, Solaris, Windows 2003/NT/XP/2007

Oracle Utilites: OEM Grid, Toad, Embarcadero DBArtisan, Geneos, CA Workload Autosys, Datapump(expdp/impdp), RMAN(restore/recover), DBMS data dictionaries, Tivoli, Winscp

Data Modeling Utilites: ERwin r7, ER Studio

Language: PL/SQL, Unix, Linux, C++, Shell script

Backup: Netbackup, TSM, Veritas, SAN, DISK, RAC clusters

PROFESSIONAL EXPERIENCES:

Confidential, Dallas, TX

Senior Oracle Database Administrator

Responsibilities:

Collaborated on Oracle 9i/10g/11g/12c logical and physical database design, implementation, and maintenance on Unix/Linux/Solaris platforms
24/7 on-call Production Support most of which are high visibility databases (high transaction OLTP, data warehouse, ETL)
Support 2000+ databases with databases ranging up to 70TB size
Support numerous 3 to 4 node RAC holding multiple instances with High Availability
Execute and monitor monthly ETL process for OLAP environments
“Follow the Sun” model in which working with Asia and Europe is critical for supporting 24/7 business needs
Responsible for buildout and testing of Oracle lifecycle Dev-QA-UAT-PERF-PROD-DR
Proficient in 12c OEM grid for everyday maintenance and performance tuning
Performance tuning on AD’s queries using various methods and utilities: AWR, ADDM, explain plan, OS Watcher, Advisor Central from OEM Grid, sqlrpt
Work in ‘Agile’ environment model where strict deadlines and quick, smart decisions are required
Create new databases and users: ensure Oracle instance parameters are properly set; control access permission and privileges are properly seen on assigned DDLs
Ensure backups (lvl1,lvl0, archive jobs) and other monitoring scripts (analyze stats, filesystem cleanup jobs) are running properly, and recovery plans are in place
Golden Gate replication extract/replicat experience on 11g databases
Implemented tech refreshes using datapump for schema refreshes or using RMAN depending on size and space of the server
Ensure DR physical standby database is always in sync with PROD and everyday health checks by creating reports in OEM
Exercise disaster recovery tests for multiple databases using dgmgrl or sqlplus for switchovers, failovers, flashback, SRDF
Installed Oracle 9i,10g/11g Database Software and Agents via dbca, Oracle Universal Installer, silent installation (response file)
Involved in database upgrades/migration (10g to 11g) & patching (PSU) in 2-4 node RAC environments; support Operating System upgrade; open Oracle SR and metalink as needed

Confidential

Data Modeler

Responsibilities:

Conduct data model reviews with business and project managers
Develop foundational understanding of DDL objects like tables, primary/foreign keys, views, synonyms, indexes all diagramed out on ERwin
Use ERwin r7 software for visual model management design
Knowledge and understanding in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, DBAs and ADs

We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume

Dallas, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship