Director, Cloud Database Administration Resume
NyC
SUMMARY
- Information Technology Director and hands - on Architect, offering about 14 years of expertise in building and managing large-scale enterprise systems on private/ public cloud and bare-metal infrastructure, for startups to Fortune 100 companies.
- Cloud Solutions expert, devops practitioner, versatile technologist - AWS Certified Solutions Architect, AWS Certified Sysops Administrator and Certified Solaris Systems Administrator experienced in AWS, VMware, Linux, UNIX and Windows environments; skilled at implementing multimillion-dollar technology transformation projects, migrating enterprise databases to cloud, and engineering automation.
- Oracle DBA Certified - expertise in HA and DR solutions, including Oracle Real Application Clusters (RAC) and Active Data Guard.
- Oracle Certified Developer - expert at performance optimization, SQL development, shell scripting, and puppet.Experienced in C, Linux Kernel development programming.
- Strong people developer and manager - experienced in building high performance global teams, fostering collaboration, and mentoring people towards delivering superior quality work.
TECHNICAL SKILLS
- AWS
- RDS
- DMS
- Oracle
- Redshift
- DynamoDB
- EMR
- Kinesis
- MySQL
- RAC
- Active Data Guard
- ASM
- SQL
- PL/SQL
- RMAN
- Datapump
- OEM Grid Control
- Exadata
- SAP Hybris
- Manhattan OMS
- MuleSoft ESB
- Splunk
- AppDynamics
- MicroStrategy
- Red Hat Linux
- UNIX
- Windows
- VMware
- EMC Data Domain
- Jira
- Autosys
- Apex
- Shell scripting
- Puppet
- C
- C++
- Perl
- PHP
- Java.
PROFESSIONAL EXPERIENCE
Director, Cloud Database Administration
Confidential, NYC
Responsibilities:
- Led the development, architecture and production support of systems and services in Confidential ’s next generation eCommerce platform which comprised Oracle AWS/RDS and RAC databases.
- Led the build, management, and support services of Big Data AWS Redshift data warehouses of click-stream data, global customer data, operational reporting, and fraud detection Analytical systems.
- Reduced CAPEX and increased agility by deploying and supporting less expensive, cutting-edge AWS solutions.
- Configured and tuned AWS Data Migration Service (DMS) for real time data replication from transactional systems to OLAP/BI warehouses.
- Recruited, managed, and mentored global DBA teams from multiple vendors.
- Implemented and matured processes to standardize operational tasks, developed several automation utilities including automation of cross-environment data refreshes and cross-region RDS snapshot copies.
- Led the performance optimization efforts - reduced the execution time of certain data migration/purge procedures from days to under 3 minutes.
- Supported data migration from legacy EBay Enterprise hosting to AWS wif PII/PCI compliance, and data integration across various enterprise and digital systems, including SAP Hybris, Order Management system, and ETL systems.
- Fostered innovation and excellence through continuous improvements, developed team SOPs, and ensured adherence to Security & Compliance policies and procedures.
- Multi-functional collaboration wif Infrastructure, DevOps, Application Architecture Leads, QA, Vendors and hosting service providers to support the next generation RL eCommerce systems.
- As a transformation service offering lead in the SDDC program, developed and deployed Operating System agnostic solution to migrate several hundreds of legacy databases from bare-metal data centers to Johnson & Johnson’s private cloud.
- Created “Accelerate for Cloud” work-flow templates to industrialize and orchestrate the various operations involved in upgrades end-to-end.
- Provided technical leadership during compliance runs to support the modernization solution’s qualification process.
- Key team member dat designed, developed, and rolled-out standard process for Application Rationalization to consolidate and sunset enterprise-wide legacy applications.
Technologies: Oracle 12c/11.x/10g/9i/8i, shell scripting, Linux, HPUX, Accelerate for cloud/eMPIR
Vice President, Database Management Lead
Confidential Chase, NJ
Responsibilities:
- Provided technical leadership; supported a very large, complex database environment comprising about 1500 RAC, Restart, Active Data Guard, and Streams databases in the Global Technology Infrastructure and Global Service Operations Tower.
- Functioned as database solutions architect and lead of the consolidated Oracle DBA team in the DevOps/infrastructure engineering services group; provided hands-on engineering, production, development, and systems support to companywide databases, including business critical ecommerce, advertisement, BI, and Newsdesk systems.
- Focused on automation to scale - developed end-to-end automation tool for cloning databases, developed puppet scripts for automatic rapid provisioning and configuration of Oracle virtual databases.
- Reviewed and deployed release code, optimized and performance-tuned queries; configured and developed scripts to quickly setup Oracle Active Data Guard for Disaster Recovery; setup replication from transactional dbs to BI data warehouses.
- Managed database projects, mentored team members, and ensured standards, license, and PCI compliance.
Technologies: Oracle 11g RAC, data guard, Red Hat Enterprise Linux, CentOS, VMware, EMC VNX, Data Domain, SQL, PL/SQL, RMAN, ASM, Nagios, shell scripting, Puppet, Jira, Perl.
Senior DBA December
Confidential, NJ
Responsibilities:
- Served as senior database engineer in the global team dat provided 24x7 production support to telecom clients across 35 countries and development support to R&D teams in USA, Europe, and Asia.
- Performed database systems design, Oracle RAC installation, upgrades, performance tuning, backup, and disaster recovery.
- Wrote code to automate and orchestrate migration of schemas/data in support of new product releases. Developed SQL scripts and PL/SQL stored procedures for database monitoring and maintenance.
- Acted as database technical expert on sales calls and training of sales team on database features.
- Optimized queries, troubleshot database issues, audited customer db environments, and resolved support cases.
Technologies: Oracle 10g/11g RAC, data guard, MySQL, Red Hat Linux Enterprise Server, IBM DS4200 SAN, NetApp NAS, SQL, PL/SQL, ASM, shell scripting, PHP, Perl.
Senior DBA/Developer
Confidential, NYC
Responsibilities:
- Setup Oracle Real Application Cluster on OCFS; upgraded Oracle 9i RAC to 10gR2 RAC; migrated databases across datacenters using custom scripts to minimize downtime.
- Developed a CRM/Order management reporting application using Oracle Apex.
- Generated consolidated BI reports for executive leadership on data sourced from multiple heterogeneous databases.
- Performed database forensics using LogMiner; automated routine database jobs; troubleshot and tuned queries.
- Developed procedures to audit unauthorized access to sensitive data and obfuscate PII and PCI data; reverse-engineered the functionality of legacy Objective C EnterpriseObjectsFramework/WebObjects code and converted it into equivalent sql code.
- Setup standby databases for DR and synced them up wif primary using custom shell scripts dat shipped and applied transaction logs from primary to standby db servers.
Technologies: Oracle 8i, Oracle Text, Solaris 8, Mac OS 10.2.x, SQL, PL/SQL, RMAN, Export/Import, Shell scripting, WebObjects, MySQL.