Supervisor, Lead Database Administrator Resume
2.00/5 (Submit Your Rating)
SUMMARY
- An innovative data and database expert with experience in unstructured and structured data model.
- Significant experience with database architecture and internal database engine along with Python, Shell programming, SQL, API interactions, Data Mining, data loading and ETL process.
- Advanced Education, including Masters in Information Systems, Bachelors in Electrical Engineering and most recently a Data Sciences Certification from Rutgers University
- Work experience in Retail, Pharmaceutical, Telecommunication industries along with experience in a consultant firm
- Seek an opportunity working at Database Administration, Data Engineer area, improving data process performance to build/enhance/automate the data platform processes.
TECHNICAL SKILLS
- Python, Unix Shell programing, SQL, Pandas, Matplotlab, Jupyter Notebook, SQL, Pl/SQL, JavaScript (D3.js, Leaflet.js), HTML/CSS, Java, Advanced Excel, VBA, JCL, Cobol.
- API Interactions, Social Media Mining, Tableau, Advanced Statistics, Machine Learning, Git/GitHub, Service one,
- Oracle RDBMS 8i,9i,10g,11g,12c, SQL Server2014, 2016, MySQL, PostgreSQL MongoDB, Couchbase,
- Oracle encryption, Standby Databases, Database/Application upgrade/patches, OEM, Toad
- Sun Solaris 9,10,11, EMC storages, Data Domain, Azure, AWS, Google Cloud, VMware, Microsoft Windows
PROFESSIONAL EXPERIENCE
Supervisor, Lead Database administrator
Confidential
Responsibilities:
- Lead more than 20 remote Oracle DBAs and 5 SQL server DBAs to provide 24/7 database support for all major revenue driving databases of the organization located in three data centers.
- Design and implement backup/recovery, disaster/recovery, archiving strategy and create/maintain the database standard for DBAs activates.
- Designed and enhanced daily data loading procedures from backend inventory management systems to product management for E - commerce websites.
- Production Supported and troubleshot the ETL procedures and provide the solution for price promotion double discount.
- Utilized Shell programing, SQL, PL/SQL load/retrieve data across a variety of application platforms.
- Provided database support for implement a B2B project using Azure Cloud for application and database development projects.
- Led a POC project that moving data from oracle database to NoSQL database in Azure cloud.
- Installed the Couchbase and Python to research on the NoSQL database and development. Completed the online training on Couchbase system management certificates.
- Research on the open source database DevOps tool Liquibase and Flyway. Installed the Liquibase, connected the Oracle database and created tasks simulating the DevOps procedure. Also researched on Liquibase commercial tool Datical.
Supervisor, Lead Oracle Database Administrator
Confidential
Responsibilities:
- As a sole DBA, provided the database support including creating Databases, tablespaces, schemas, tables and other objects.
- Developed automatic Rman backup database procedure to tapes and Data Domain using Unix shell scripts. Monitored and emailed backup failure alerts automatically.
- Cloned the production databases to non-production environments using Rman backup and point-in-time recovery methods as well as export/import by data pump.
- Worked on database servers by partitioning raw disks and adding them into ASM Storage.
- Monitored the database O/S performance and troubleshoot operating system errors.
- Implemented Oracle Enterprise Manager as the primary tool to manage and monitor databases performance.
- Upgraded all Oracle databases to the latest release 4 times, most recently to Oracle 12c. Created and managed database upgrade/migrate projects, coordinating across all business and application areas.
- Provided production performance support through the utilization of run stats analysis; index rebuilding and both ad-hoc and scheduled table reorg procedures.
- Supported pre-release QA and performance testing efforts, certified all database code prior to production release; and provided post-release management of database performance
- Provided full support for all PCI compliance audits since 2007, and all SOX Audits since 2009. Implemented Encryption of tablespace and table columns using Oracle Encryption feather.
Database Administrator
Confidential
Responsibilities:
- Installed and managed Multiple Oracle releases including 8i, 9i and 10g. Applied Oracle database version patch sets and security patches.
- Installed Oracle 10g application server and migrated portal application to support DuPont seeding and potting application migration from legacy system.
- Managed user/security administration and implementation. Automate user management processes by adding DDL triggers.
- Setup the Rman backup procedure and tested database disaster recovery plans.
- Web enabled Oracle RDA reports internally for daily checking the database configuration.
- Maintained the Oracle Names Server.
- Setup the Rman backup procedure and tested database disaster recovery plans.
- Provided 24x7 remote DBA support for multiple clients. Responsible for proactive disk and storage management, including datafiles, archive and redo logs as well as system backups. Managed user/security administration
- Developed automatic monitoring and backup procedures for Oracle in both UNIX and MS WinNT/2000 environments.
- Provided database and application performing problem investigation and resolution also database recovery after a hardware failure;
- Installed Oracle9i application server on both UNIX and Microsoft WinNT/2000.
- Installed MS SQL server 2000 in a client/server environment, researched on backup/recovery, security and routine database administration tasks.
- Developed and maintained RDBMS and procedural documentation. Provided Oracle performance analysis and recommendations report monthly.