Technical Lead DBA Resume

SUMMARY

Over 10 years of experience in database administration, architecture and development
Superior SQL and PL/SQL development and performance tuning skills
Strong data modeling and data architecture experience
Family with Big Data and NoSQL(Hadoop, HDFS, Hbase, HIVE, PIG, MongoDB …etc)
Experienced in Linux Administration, strong with scripting and troubleshooting
Experienced in J2EE, .NET and Web based 3 - tier application. Strong in Java and C#
Self-starter, able to work and learn independently

TECHNICAL SKILLS

DBMS: Oracle 9i/10g/11g/12c (RAC, ASM, Dataguard, GridConrol, RMAN, GoldenGate), Sybase ASE15, Sybase IQ, MySQL

Operating Systems: Red Hat Linux, Sun Solaris, Windows

Languages: SQL, PL/SQL, Java, C#, C/C++, Perl, Shell script, Ruby on Rails

Others: TOAD, TeamQuest, TKProf, IBM Tivoli

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead DBA

Responsibilities:

Manage over 100 Oracle RAC databases up to 10TB on both OLTP and data warehousing in RAC/Non-RAC/VCS environment
Train and instruct other DBAs and work with client, system, and network team to resolve problems with application systems.
Built 2 Nodes 11gr2 RAC clusters on Red Hat Linux. Create ACFS File System.
Add 3rd Node on a 2 nodes 11gr2 RAC clusters, upgrade Clusterware and database from 10.2/11.1 to 11.2
Migrated/Converted a non RAC database on Windows file system to a RAC database on Linux with ASM.
Install/patch Oracle RAC databases (from 10.2 to 11.2) and Oracle Client.
Migrated Oracle RAC database from 10.1/10.2/11.1 to 11.2.
Created 11.2 RAC One Node database and implemented online relocation.
Install 11.2 Oracle Restart on standalone server.
Upgraded Oracle Grid Infrastructure from 11.2 to 12c on Redhat Linux 5.
Upgraded database from 11.2 to Oracle 12c, and convert it to PDB and plug into CDB.
Upgraded OEM from 10g to 12c, Deploy 12c agent on all Oracle database Servers.
Wrote Perl script to proactively check staled objects, monitor unused indexes and long run query cross all databases.
Work with SA to deploy Oracle 11.2 on Redhat Linux 6 with best practices, configure the storage with Multipath and Udev Rule for ASM.
Manually collect stats, recommend hint, implement SQL profile/SQL outline for better execution plan.
Tuned SQL and PL/SQL performance using GridControl (AWR/ASH/ADDM), SQLTrace, TKProf, wait event etc.
Implement rang/list/interval partition for large tables and provide data modeling support to development groups.
Refresh DEV/PPE using RMAN replication or Datapump.
Migrated ASM disks from 21GB USPV to 100GB VSP on 20 Clusters
Proactively manage ASM storage usage, and significantly reduced storage related alerts.
Charged with Solid State Disks (SSD) migration for I/O intensive workloads.
Lead all DCR test, perform switchover, failover, reinstate and covert to snapshot.
Create physical Standby databases, setup Active Data Guard(ADG) and configure data guard broker(DGB).
Use RMAN incremental backup to sync standby database with primary database in Data Guard.
Manage Date Guard and Resolve Gap.
Wrote RMAN backup and restore scripts, troubleshot backup failure.
Used Golden Gate to setup Bidirectional Replication between two Oracle databases.
Perform failover and Reinstate in Golden Gate Replication environment.
Conduct technical research and evaluate Exadata.
Manage over 20 Sybase ASE 15.0 and Sybase IQ
Setup Sybase clustering and Sybase Replication Server.
Develop/maintain procedures on Wiki to comply with IT best practices.
Participate in SOX and SAS70 Audits.

Confidential

Sr. Oracle DBA/Developer

Responsibilities:

Designed, architected, and built Oracle databases from scratch.
Installed/upgraded/patched Oracle RAC databases (9i to 10g) on Red Hat Linux System.
Designed, implemented and supported database backup, recovery systems(RMAN), database migration, High Availability(Data Guard) and data migration (SQL Loader, export/import)
Tuned the SQL and database instance to reduce overall database time and improve the billing (report) process from days to hours.
Designed the data model, created ER Diagrams using Toad Data Modeler.
Wrote stored procedures using SQL and PL/SQL, mentored application developer to improve the SQL and PL/SQL performance.
Installed and tested software, performed upgrades and patches. Ensured database integrity, optimal system performance and security
Used C# to develop User Interface (Windows Form) and Business logic (Web Service, IIS).
Used Java (jsp/jdbc), Tomcat to develop an online exchange usage report system.
Wrote batch shell script to monitor the daily database usage and send out alert email.

Confidential

Programmer Analyst

Responsibilities:

Utilized Java to develop the online real-time streaming data system.
Used JSP, Servlet, and JavaScript to develop the online registration system.
Designed the data model, create DB objects in MS SQL Server database.
Used JDBC to access MySQL and MS SQL Server database and store the user information.
Used Perl, PHP to develop an automatic testing tool.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship