Lead Dba Resume
SUMMARY:
- Over 15 years of experience in all aspects of Oracle Database Administration on Unix/Linux and Windows platforms in OLTP/VLDB/DataWarehouse environments; SQL and PL/SQL development, Logical and Physical Database Design, Data Architecture.
- Technical management of various development and DBA projects.
- Three years of Sybase and MS SQL Server DBA.
TECHNICAL SKILLS:
Hardware: Exadata, SUN, IBM, DG, HP, AT&T, IBM 370EMC (VMAX, CX, DMX), NetApp, IBM Shark, DataDomain
Operating Systems: Sun Solaris, Linux(RHEL), IBM AIX; HP/UX, Windows; Novell NetWare; OS/MVS
Database Systems: Oracle 12c, 11gR2, (RAC, DataGuard, ASM), Golden Gate, RMAN, Oracle Text; MS SQL Server 6.0; SYBASE System 10.
Languages: SQL, PL/SQL, Unix KornShell, TRANSACT/SQL, XML.
CASE Tools: ERWin, Rational Rose (UML), Designer/2000.
Miscellaneous Software: EM 12c Cloud Control, SQLBackTrack (BMC), Veritas (Volume Manager, File System, Cluster Server, Net Backup for Oracle), Oracle Client tools, JDBC, CA TSREORG, DBArtisan, SQL Explorer, TOAD, CA - ManageIT.
EXPERIENCE:
Confidential
Lead DBA
Environment: Oracle 11gR2, 12c, RAC, DataGuard, ASM, GoldenGate, Oracle Linux, Exadata, EM 12c Cloud Control.
Responsibilities:
- Technical supervision of a DBA team
- Support of Oracle databases (Dev, QA, UAT, Prod) on Exadata and non-Exadata platforms (all RAC)
- Support of External Customers of Confidential Health Solutions
- Implementation of a DBaaS Private Cloud using EM12c Cloud Plugin
- Implementation of Self Service DB Operations Portal for Dev teams
- Software installation, upgrade, patching in Oracle environments
- Database and application performance tuning
- Planning and execution of annual DR tests
- Development of Unix and SQL scripts for database backups, housekeeping, monitoring, etc.
- Development of OEM jobs, Metric Extensions, Reports
- Set up of OEM Incident Rules as part of the overall monitoring/alerting of the database infrastructure
- Backup/recovery using RMAN, and DataPump
- Implementation of Security/Auditing, remediation of issues identified by 3rd party auditors
- Database migrations: non-Exadata to Exadata; Oracle 11g to 12c.
Confidential
Lead DBA
Environment: Oracle 11gR2, RAC, DataGuard, ASM, GoldenGate, Sun Solaris, RedHat Linux, EMC, NetApp, Veritas.
Responsibilities:
- Subject Matter Expert (SME) for Oracle virtualization (Oracle on VMWare)
- Participation in design reviews of complex configurations and new products: RAC, DR, Replication, Backup/Recovery, etc. Close partnership with the Bank’s Engineering group with the goal to deliver the required tool set to the DB Support teams.
- Technical supervision and mentoring of junior and middle level DBAs (Oracle, Sybase, MS SQL)
- DBA Support of production and development servers (globally over 3000 databases).
- DBA support of Fixed Income, Commodities Trading, and Risk systems
- Planning and Implementation of database Disaster Recovery configurations using Oracle Data Guard and Golden Gate replication. Participated in several industry wide Isolation/DR tests, both as a DBA and as a Team Coordinator. Conducted numerous db failover tests per Confidential Application Certification requirement.
- Planning and Implementation of HA solutions using Oracle RAC and Veritas Cluster Server
- Implementation and maintenance of complex replication configurations using Golden Gate: multi-site, bi-directional, cascading
- Physical database design, capacity planning
- Database and applications tuning
- Backup/recovery using RMAN, SQL BackTrack, and Net Backup
- Resolution of production issues with subsequent root cause analysis
- Installation and upgrade of Oracle software
- Applications schema maintenance
- Applications development support
- Development of Unix shell scripts, PL/SQL stored procedures, and triggers
- Logical/physical data models design/implementation
- Implementation and support of various data replication solutions: Oracle snapshots, Golden Gate software.
- Participation in various global technology initiatives: Standards for Oracle, DB Security, auditing, proactive space management, database monitoring and alert management, automation of Oracle software installation and patching, Oracle backups using DataDomain devices with De-duplication technology, etc.
- Currently working with the Confidential DB Engineering team on the implementation of a standard configuration of Oracle on VM with direct NAS (NetApp) for Confidential IB.
- Conducted Proof Of Concept for Oracle 11gR2/Linux Extended RAC (stretched RAC), which involved a series of performance and failure tests in the lab cluster environment with distance simulators.
- Designed and implemented multi-site bi-directional replication configurations using Golden Gate software.
- Implemented various DR configurations using Oracle Standby Database: DataGuard/DataGuard Broker, Manual Standby (older versions of Oracle8i, OracleSE)
- Participated in the design and implementation of various HA solutions for trading systems using Oracle RAC and Veritas Cluster Server.
- Implemented multi-site Oracle RAC system: two 3-node RAC clusters with data replication using GoldenGate - Risk applications.
- Responsible for ongoing Development/QA/Production support of Commodities Trading systems with data replication using Oracle Snapshots (schema maintennace, database/query tuning, problem resolution, standard DBA support).
- Performed a preliminary evaluation of the current Oracle environment at Confidential . Provided recommendations on database operations, database failure detection and reporting, backup procedures, etc.
- Performed numerous installations and upgrades of databases to the latest Oracle releases.
- Analyzed and resolved numerous performance problems in various databases.
- Provided advisory services to many applications groups. Assisted applications groups in query tuning, schema design and maintenance, PL/SQL development, and the use of Oracle features. Developed stored procedures/triggers.
- Performed Logical Data Model reviews and physical schema implementations.
- Developed numerous Unix shell scripts for: database backup/recovery, proactive database monitoring, failure detection, data archiving, automated database cloning, Golden Gate support tools, etc.
- Developed specifications for the standard database installation process based on Confidential policies and procedures.
- Participated in the development of the new LUN standards for SAN storage.
Confidential
Senior Database Architect/DBA
Environment: Oracle9i, Oracle8i, Sun Solaris, NT, EMC Symmetrix.
Responsibilities:
- Data modeling, logical and physical database design
- Database tuning
- Production Database support (installation, maintenance, problem resolution)
- SQL Tuning
- Development of PL/SQL stored procedures and triggers
- Participated in the analysis of business requirements, created and maintained Logical and Physical data models, implemented physical schema design.
- Supported development groups (Java and Delphi), provided assistance in query design.
- Successfully tuned numerous complex queries (joins of over 40 tables).
- Implemented Snapshot replication for remote sites.
- Planned and implemented Oracle environment, installations, upgrades, creation of new databases, data conversions, and other database projects.
- Installation and upgrade of Oracle9i (9.2.0.2). Configuration of the new 9i database which serves as Operational Data Store and intermediate storage for the integrated messaging component. Implementation of Oracle9i XML DB.
- Development and implementation of data extracts, and XML document loads.
Confidential
Senior Operational DBA
Environment: Oracle8, Oracle8i, IBM AIX, Linux, SAP 3.1, 4.6
Responsibilities:
- Oracle Production Database support (24x7)
- Installation and Upgrade of Oracle software including client tools
- Planning and coordination of database projects
- Logical and physical database design
- Backup/Recovery procedures
- Performance monitoring and tuning
- Production problems resolution
Confidential
Senior DBA
Environment: Oracle8i, Sun Solaris8, NT, Veritas (Cluster Server, HA for Oracle, Net Backup, PowerTier)
Responsibilities:
- Configuration and maintenance of Oracle8i environment on development and production servers
- Configuration of Oracle HA environment using Veritas Cluster Server
- Physical database design and implementation using Veritas Volume Manager and Quick IO option
- Installation and Upgrade of Oracle client and Server software
- Database backup/recovery procedures using RMAN and Veritas Net Backup
- Database monitoring and tuning
- Configuration of Veritas Net Backup Agent for Oracle
- Database schema maintenance
Confidential
Senior DBA
Environment: Oracle8i, Sun Solaris8, NT, Designer 2000
Responsibilities:
- Supervision and training of junior DBAs and Database Developers
- Participation in all phases of project life cycle
- Planning and coordination of database projects
- Logical and physical database design using Oracle Designer/2000
- Maintenance of Oracle8i database environment, Installation of client software for Java developers
- Development and implementation of database backup/recovery and disaster recovery procedures
- Development and implementation of semi-automated procedures for Oracle Failover
- Implementation and maintenance of fully automated Oracle8i Standby Database environment (configured Standby Database, developed scripts for automated operations and database switchover)
- Evaluation of database related third-party software
- Application and database performance tuning
- Development of PL/SQL stored procedures for various real-time multi-tier Web applications
Confidential
Lead DBA
Environment: Oracle7, Unix (DG/UX, HP/UX, NT), MS SQL Server v.6.0, Sybase System 10, Mainframe
Responsibilities:
- Technical and administrative supervision of the DBA group
- Supervising a group of 5-8 DBAs and Data Modelers
- Training and coaching of junior DBAs
- Participation in all phases of project life cycle
- Planning and coordination of database projects
- Operational support of numerous Oracle databases
- Logical and physical database design, SQL and PL/SQL development
- Data analysis using Oracle CASE Method and IDEF1X methodologies. Data modeling using CASE tools (Oracle Case, ERWin). Data normalization, table design, physical database design based on functional requirements, expected data volumes, and access patterns
- Third party package evaluation
- Evaluation of Customer Billing software (Banner by SCT), DSS Smartstream by D&B, Fuel Purchasing system by Confidential
- Installation, maintenance and support of database management systems and related software
- Installation of various major and minor releases of Oracle v5, v6, Oracle7, Sybase System 10, MS SQL Server 6.0
- Database performance monitoring and tuning
- Application query tuning. Analysis of database access patterns. Database space monitoring and reorganization. Performance statistics monitoring. Tuning of Oracle instances.
- Creation and maintenance of databases for various application projects.
- Database instance planning and creation based on applications system requirements. Creation of various database instances in different environments: development, quality assurance, production
- Technical support of in-house as well as third party applications