Oracle DBA
Certified Senior Oracle 11g DATABASE ADMINISTRATOR
SUMMARY OF QUALIFICATIONS: Certified senior-level Database Architect and DBA with areas of expertise including: Infrastructure Planning, Database Design, Install, Manage, and Support Oracle, PostgreSQL databases in Production, Development, QA, and Disaster recovery environments on UNIX and Linux. Flexible, with strong organizational skills and outstanding record of completing multiple enterprise projects simultaneously.
TECHNICAL SKILLS:
• Database Administration: MongoDB 2.4(4 mth), PostgreSQL 9 (1.75+ yrs), Oracle 11g, 10g, 7 (5+ years).
• Data Architect (12+ years): Logical and Physical data modeling, ER diagrams, Business rules, Data flow and Process Models using Oracle Designer and (1+ years) Rational Case tool for Physical designs.
• Programming (14+ years): Expert in PL/SQL, SQL, Oracle Pro*C, Shell scripting (Korn, C), some (4+yrs) C, MDL programming, (1+ yrs) perl and bash scripting.
• Operating Systems: HP UNIX 10, 11i (last 14+ yrs), Solaris UNIX (2+yrs), Windows, Red Hat Enterprise Linux 6 (last 3+ years).
• Networking: TCP/IP, FTP, DHCP, NFS mounts, and iSCSI drives, setup DNS server
• High Availability (2.5+ yrs): Oracle 11g (Grid, RAC, Streams), and Postgres (streaming with pgPool-II 3.2).
• Disaster Recovery: Oracle Data Guard, Oracle Streams, Oracle Flashback Recovery, RMAN
• Utilities: ODBC, JDBC, OpenSSL, ssh, rsh, OCFS, VM VirtualBox, VMware Workstation 9
o Oracle: Enterprise Manager OEM, Automatic Storage Management ASM, Backup & Recovery Manager RMAN, Flashback (Table, Query, Data Archive, Database), Tablespace Point in Time Recovery (TSPITR), Export(expdp)/Import(impdp), Scheduler, and Diagnostic
o PostgresSQL: Enterprise Manager PEM 3, pgAdmin, psql, pg_dump, pg_restore, PL/pgSql, pg_ctl, etc.
• Development Platform & Design Tools: Rational Apex (14+ yrs), MyEclipse (1+ years)
DBA CERTIFICATIONS/TRAININGS:
• Successfully passed:
o Oracle Database 11g Administrator Certified Professional OCP exam Jun-2012
o Oracle Database 11g Administrator Certified Associate OCA exam Dec-2011
o Oracle Database 11g Certified SQL expert exam Nov-2011
• Completed Introduction and Advanced PostgreSQL 9 Administration trainings Oct-2012
TECHNICAL SUMMARY:
• Senior Database Architect and Oracle Server DBA experienced in designing, implementing, and maintaining server infrastructures and databases for several enterprise database applications in development, production, and Software quality assurance QA environments.
• Planned, evaluated, installed, and implemented new solutions after presenting and coordinating with Systems Engineers, Developers, System/network Administrators, and Project Managers.
• Extensive DBA experience with Oracle Server 7, 10g, 11g, and PostgreSQL 9 on HP UNIX and RHEL 6.
• Installed and configured Oracle and PostgreSQL databases in High Availability Architectures:
o PostgreSQL (Hot standby streaming) with pgPool II 3.2 to support failover/load balance
o Oracle 11g Grid - Real Application Cluster (RAC) on two nodes running RHEL 6.
• Capacity and Storage Planning on SAN, NFS.
• Designed and implemented backup recovery procedures, and implementing disaster recovery strategies.
• Expert in UNIX-Linux SQL shell scripting to automate, fine tune and streamline operations.
• Expert in database diagnostic, task scheduling, globalization, resource management, and database security.
• Worked with programming team to provide tuning and optimization of complex scripts, queries, stored procedures, triggers, and user defined functions.
• Best practices in software development life cycle with quality assurance QA, for past 14 years.
• Designed and created documents of top level design, detail design, test plan/procedures, and user manuals.
EMPLOYMENT HISTORY:
Nav Canada, Ottawa, Ontario Sr. Production/Development DBA Sept 2004 to present
Nav Canada is a private non-share capital company that owns and operates the civil air navigation system of Canada.
• Contributed in the deployment and enhancement of “Canadian Automated Air Traffic System (CAATS)” as a Technical Lead of Data Engineering team of 4 engineers.
• Performed Database Administration of Oracle and PostgreSQL, Data modeling, and Software development.
• Coordinated requirements and enhancements with System & Software engineering teams and customers.
• Installed, upgraded, designed, implemented, and configured Oracle 7 on HP UNIX and Oracle 9i, 10g, 11g, PostgreSQL 9 database servers on HP UNIX 11i, Windows, and Red Hat Enterprise Linux 6.
Major contributions:
• Installed, configured and Supporting Oracle RAC and PostgreSQL databases in High Availability Architecture that allows automatic failover, load balancing, real time archiving and DB restore to the failed node.
• Designed logical, physical data models; created Business Rules, ER diagrams, and Process models, with their implementation software code in reusable dynamic PL/SQL stored procedures, and SQL - UNIX shell scripts.
• Managed database storage structures, Administered user security, Managed schema objects, and undo data.
• Created scripts automating the maintenance processes using cron jobs and Oracle scheduler.
• Designed and created Top level design, to store the in-active UML object data of real-time CAATS application, to off-line database server and allow ad-hoc query capabilities on it. The design also includes detail design of physical data model, sample report formats and data flow within nodes over LAN.
• Created several presentation documents for the migration of Oracle DB servers, Development Platform, and Middle tier software products from HP UNIX to RHEL 6 and shared them with Management, & team leads.
• Installed MongoDB on RHEL 6 and evaluated it for application log data archives and analytic activities.
• Installed and configured Automatic Storage Management (ASM) of Oracle 11g on RHEL6.
• Migrated database servers from Oracle 7 (HP UNIX) to Oracle 11g on RHEL6, also upgraded Data Models from Designer 2000 to Designer 9i.
• Supported Oracle 11g on RHEL 5 for the ETL application transforming AIS data to CAATS data model.
• Optimized Storage Parameters solving the problems of rollback segments, further tuned the System Parameters to solves the “process hanging” problem of simultaneous long running DML processes.
• Performed physical (online/offline) backups using RMAN/user-scripts, and logical backups using Data Pump Export/Import (expdp/impdp, exp/imp), SQL-loader (sqlldr) utilities.
• Configured Flash Recovery area for quick recovery. Created encrypted, multi-section, compressed backup sets, backups with Long-term retention, and incremental backups.
• Recovered databases from; lost redo log groups, password loss, and loss of control file. Performed time based/user managed incomplete recovery.
• Duplicated databases using RMAN, and Enter...
Login or Register to view the full resume.
