SUMMARY

• An accomplished Database Specialist with over 15 years of experience specializing in Database Administration, Designing and architecting in fast paced 24x7 environments.
• Expert level technical skills in Database Management specializing in areas like Oracle, Actian Vector (Columnar DB), Real Application Clusters, MySQL Cluster, MySQL, PostreSQL, and Cassandra.
• Core experience with Backup and Recovery, Disaster Recovery, Database Security, Data Migration, Capacity Planning, Data Consolidation, High Availability, Database Upgrade/Patches, Data Center Migrations, Amazon RDS, Amazon EC 2, Amazon Redshift, Performance Tuning, Database Design and Implementation.
• Excellent Team player, highly motivated and dedicated to achieve team and company objectives.
• Have the ability to do multi - tasking and deliver projects in time without supervision.
• Experience in setting up and administering Oracle, Actian Vector (Columnar DB), Real Application Clusters, MySQL Cluster, MySQL, PostreSQL, and Cassandra databases.
• Experience with Backup and Recovery i.e. RMAN, expdp, impdp in Oracle. Copydb, movedb in Vector.
• Mysqldump, vxfs snapshot, ndb mgm backup, ndb restore in MySQL. pg dump, pg dumpall, pg basebackup in PostgreSQL, nodetool snapshot keyspace in Cassandra, etc.
• Experience in Oracle Data guard for High availability (HA), PostgreSQL and MySQL replication and standby.
• 10+ years Experience in Production support of more than 200 DBs (Oracle, MySQL, Vector, PostgreSQL) running on Linux and Solaris.
• 10+ years Experience in supporting large OLTP database i.e. 11TB.
• 10+ years Experience with setup and administration Oracle Database Security using Profiles, database privileges and roles, encryption (TDE).
• 10+ years Experience with Tuning Linux/Unix Server, Databases, JVM, Caching.
• 3+ years Experience managing OpenStack.
• 3+ years Experience managing Cassandra.

TECHNICAL SKILLS

Platforms: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10.Linux (RHEL, OEL and SUSE), Windows NT/2000/ XP/ 2003/2007/2008.

RDBMS: Oracle 7.x 8i, 9i, 10gR2, 11gR2, 12c Action Vector 3 and 4.

PROFESSIONAL EXPERIENCE:

Confidential

Lead Database Administrator / Database Manager

Responsibilities:

• Working cohesively with geographically distributed team of architects, managers and individual contributors.
• Quality assurance management of technical designs and deliverables and ensuring linkage to program objectives and the technology roadmap.
• Resolution of technical issues between vendors, business partners and technology teams.
• POC and Technology evaluation for Database Technologies, Big Data Technologies
• Optimizing Oracle, Action Vector, MySQL, PostgreSQL and NoSQL databases. Architecting Databases for Oracle, Actian Vector, HBase.
• Handling Performance tuning Escalations for RDBMS and NoSQL Databases.
• 24x7 production support for several mission critical systems which utilize multiple Oracle 10g and 11g, 12c, Vector 3 and 4.2., PostgreSQL and MySQL databases. .
• Installation, configuration, administration and maintenance of Oracle 10g /11g/12c RAC/ Vectorwise 2.5/Vectorwise 3/Vector 4.2/MySQL/PostgreSQL/Cassandra databases.
• Performed upgrades from Oracle 8i to 10g, 10gR2 to 11gR2, 11gR2 to 12c, Vector 2.5 to 3, 4.2. 5.0
• Migrated databases from Sun Solaris SPARC to Sun Solaris x86.
• Manage AWS databases on RDS, EC2, and Redshift.
• Setup, configured and maintained oracle data guard/active data guard (primary and standby databases) for disaster recovery, high availability and data protection.
• Setup, configure and maintain PostgreSQL and MySQL standby/read replicas using replication.
• Data Migration from one infrastructure to another.
• Used shell scripting for automation of job scripts, for Startup and Shutdown, cloning, backups, Health Check of Databases, Analyzing tables and Rebuilding Indexes, monitoring, managing replication, etc.
• Design Databases for performance, disaster Recovery, site failover, etc.
• Migration from file based ISAM databases to RDBMS using different tools.
• Assist developers in Data Modeling.
• Use import/export, export data pump (expdp/impdb), SQL Loader, vwload, mysqldmp, pg dump.
• Installed and Implemented Backup and Recovery Procedures, Implemented Hot, Cold, Logical backup, Data Guard, and RMAN, vxfs snapshot, pg basebackup,.
• Downsizing and defragmenting the Very Large LOB tables by export/ import.
• Optimize/Vaccum/reindex for PostgreSQL/MySQL,
• Setup Cassandra, Performance Turning (Caching, Compaction, Compression), Backup and Restore (using nodetool snapshot, incremental backup, commitlog), Monitor log, Garbage collection, System level monitoring, repairing nodes, scaling in and out etc.
• Performance monitoring and tuning using SQL Trace, TKPROF, Explain Plan, STATSPACK, AWR, ADDM
• Configured/used on Automatic storage management (ASM)
• Configured Streams to capture propagate; apply changes in multiple databases.
• Installation, administration and maintenance of Oracle Streams / Golden Gate (Replicated Portfolios/Lists to Strategic Alerts (SAS) to broadcast portfolio changes to other Confidential units.
• Load Balancing, Databases/Schemas/Table defragmentation/partitioning for faster performance using export/import/shrink & Move procedures.
• Storage Management
• Used OEM/Grid Control for monitoring
• Designing the security and database access strategies.
• Capacity planning, partitioning and bench marking.
• Developed Shell scripting for database operations and monitoring.
• Work with Storage Administrators for EMC/VMAX allocations; work with iostat and IOPS to get an optimal LUN configuration.
• Work with Network Administrators to solve critical network issues.
• Work with Unix Admins for Server/Veritas Cluster/ZFS/CFS/VxFS/Server issues.

Senior Database Engineer

Responsibilities:

• NBCi was created through the combination of Snap, Confidential .com, and Confidential .com.
• It provided a comprehensive online experience to users worldwide via Internet search and directory, community, shopping, e-commerce, multimedia and entertainment services across all bandwidths.
• I was one of the three DBAs who managed the Oracle, MySQL and PostgreSQL databases.

Confidential

Database Administrator

Responsibilities:

• Confidential is a specialist in global integrated logistics, delivering comprehensive supply chain solutions to its customers worldwide.
• Fritz provides flexible door-to-door transportation and material management through sophisticated information systems, placing its emphasis on simplifying processes and reducing overall transportation costs.
• The Fritz network is composed of highly trained professionals in more than 450 locations in some 115 countries.