We provide IT Staff Augmentation Services!

Lead Dba/architect Resume

Burlington, MA

SUMMARY

  • Over ten years as DBA/Architect in Fortune 50 companies like Walmart eCommerce, Wells Fargo Bank, GAP. Designing 24/7 highly available solutions to meet SLA’s using cutting edge technologies ranging from Infrastructure, BigData, NoSql, RDBMS databases, Storage and backups layers.
  • Strong lead DBA abilities working with E - commerce, Data Warehousing projects on a VLDB environment. Performed performance tuning on databases ranging from simple to complex environments, Backup and Recovery of databases, Database Clustering, implementing high availability solutions using Data Guard, Standby, Gloden Gate.
  • Oracle DBA with ver 12c/11g/10g/9i/8i with OLTP and Data Warehousing experience.
  • Installed, Configured and Administered Hortonworks HDP 2.x/ HDFS clusters.
  • Implemented Hadoop Eco-system dat includes Pig, Hive,Hbase,Sqoop, Map reduce, Yarn, Zookeeper, Oozie, Flume.
  • Installed and Configured Hadoop monitoring tools like Ganglia, Ambari, Cloudera Manager.
  • Cassandra database administration.
  • Supported more TEMPthan 400 databases overall on various UNIX platforms - Solaris, HP, AIX/Linux/NT.
  • Implemented more TEMPthan 100 RAC installations.
  • RDBMS and Nosql database modeling.
  • Installation of Oracle RAC and non-RAC software on production and non-production systems in Oracle versions 10g/11g/12c.
  • Created and administered databases in ASM and on Filesystems.
  • Database cloning using RMAN, converting non-ASM to ASM for storage.
  • Setup Replication using Data Guard/Standby, Gloden Gate/Shareplex.
  • Setup both logical and physical standby databases, use sql apply.
  • Extensive use of RMAN duplicate from active database, and other duplicate options.
  • Participated in database upgrade projects - Oracle Upgrades from Oracle 10g to 11g/12c, 8i/9i to 10g. Also critical patches and other patch application.
  • Provide Failover and Switchover for the replicating databases.
  • Setup Enterprise Manager Grid Control and manage complete database, and other application servers using it.
  • Data Warehouse creation, ETL using oracle tools and Business Objects.
  • Performed Database Partitioning, and configured materialized views, and extensive use of SQL*loader and export and import datapump utilities.
  • Expertise in Performance tuning using scripts(based on v$views), EM Grid Control and 3rd party tools.
  • Job Scheduling using scheduler, cronjobs, autosys
  • Troubleshooting application level issues using tkprof/explain plan, appropriate index creation, bitmap indexes, and at OS level using SAR, VMSTAT, IOSTAT, TOP etc
  • Database Sizing, Capacity Planning and building Very Large and High Performance Databases.
  • Mentoring DBAs and documentation of database standards and policies.

TECHNICAL SKILLS

RDBMS: ORACLE 12c/11g/10G/9.2/8, MYSQL4/5, Sybase 11.5, MS SQL Server 2014/2012/2005

DBA Tools: Oracle 12c/11g Grid, OEM, Oracle Packs, Oracle Gloden Gate, Shareplex, Toad, DBA Studio, SQL Lab, DB Artisan, SQL Navigator, BMC Patrol, SqlBackTrack

Hardware: M9K, DL580, SUN E4500, E6500, E10K, HP 9000, IBM RS 6000, IBM Blade Servers, Compaq Server

OS: SUN Solaris 10/8 2.6/2.5, AIX, Red Hat 6.5/5.0/4.0/3.0, linux x86, HP-UX 11.0, HP-Linux, SCO- Unix, Windows NT/2003, Novell

Languages: PL/SQL, TSQL, Unix Shell Scripting, PERL, C, C++, PRO*C, Basic, Cobol

Software/Other: AWS, MS Azure, RDS, Aurora, Hadoop, NoSQL, Couchbase, Apache/Datastax Cassandra, MongoDB, Hive, Spark, Pig, HBase, Erwin, SAP Business Objects Data Services, BI 4.x, SAP ECC 6 Basis, Quest me/Watch, Oracle 10/9iAS, HP-PPM, Apache Server, Veritas Netbackup, Autosys, Powerdesigner, Powerbuilder, SQL Studio, Developer 2000, Forms/Reports, ODBC/JDBC, Brio

PROFESSIONAL EXPERIENCE

Confidential, Burlington, MA

Lead DBA/Architect

Responsibilities:

  • Architecture, sizing and implementation for Cassandra Clusters on Cloud (AWS/Openstack) including install, configure and upgrade DSE v3/4/5 (Cassandra v 1/2.x) and OpsCenter v 4.x/5.x.
  • Create and Support Hortonworks Hadoop Clusters.
  • Resize Cassandra & Hadoop Clusters.
  • Typical Clusters range up to 64 nodes across multiple Data Centers.
  • Fine tuning Cassandra & Hadoop related parameters.
  • Troubleshoot Cassandra read/write latency issues using nodetool cfstats/tpstats/cfhistogram column-families.
  • Configure backup, alerts, repairs and monitoring of Cassandra clusters, in conjunction with Nagios/Command Center.
  • Create Keyspaces, Column families, working with application teams.
  • Design and Implement access controls/security on DSE Cassandra clusters.
  • Design, implementation and maintenance of multiple Hadoop/ Big Data, Infrastructure and clusters.
  • Implemented Hadoop Eco-system dat includes Pig, Hive,Hbase,Sqoop, Map reduce, Yarn, Zookeeper, Oozie, Flume.
  • Installed and Configured Hadoop monitoring tools like Ganglia, Nagios, Ambari, Cloudera Manager.
  • Play key DBE role on architecture of new services for walmart ecommerce databases.
  • More TEMPthan 30 Oracle 11g/12c RAC Cluster/database installs, delivering go-live production and beyond support
  • Design high availability and replication solutions using Gloden Gate, including data center switchovers, gloden gate upgrades to ver 11.2 and 12c.
  • Critical Site-facing production database support for walmart.com, inventory, asda.com (UK Groceries), samsclub.com databases
  • Setup Active Data Guard databases, DB switchovers, using both manual and DG Broker.
  • Administer Oracle Exadata X6-2 for Samsclub databases.
  • Install and configure 12c OEM, agents using agentdeploy, monitor DBs, schedule jobs, integrate GG plug-in, and define thresholds.
  • Oracle 12c GI and database upgrades including Gloden Gate
  • Performance Tuning for Production Databases using v$ views, SPM/SQL baselines, tuning, Cloud Control/OEM.

Confidential, Albany, NY

Lead Oracle DBA

Responsibilities:

  • Build more TEMPthan 20 11gR2 RAC clusters with ASM. The environment was AIX 5.3 and Linux.
  • Setup Dataguard in Oracle 10g and 11g using rman and active standby 11g feature.
  • Configure RMAN backups and restore other environments from production (DB Cloning). Also, configure OEM grid for monitoring and other dba tasks.
  • Work with developers on database issues - connectivity, performance and monitoring. Also halp them in debugging app/db issues.
  • Applying db changes, schema refreshes using datapump, and used sqlldr.
  • Upgrade Oracle 9i to 11g and 10g to 11g. Apply CPU and other patches.
  • Database size ranging upto 50 TB size.
  • Extensively involved in Data Encryption using ASO/TDE.
  • Worked on datawarehouse access strategies of large objects.
  • Setup DBVault (database vault) by creating realms, command rules, policies and roles.
  • Resolve Performance Issues in OLTP as well datawarehouse environments using ADDM, RAC AWR, ASH reports.

Confidential, San Francisco, CA

Sr. Oracle DBA

Responsibilities:

  • Built 2-node RAC cluster on 11g
  • Database Migration from 10.2.0.4 to 11.2.0.2.
  • Database Cloning and replication setup using rman “active database” 11g option
  • Maintaining and Tuning both OLTP and Data Warehouse databases - loading data to data warehouse, performance tuning for instance, SQL’s, star schema.
  • Used Partition Exchange Loading, monitor parallel execution performance, materialized views, and compression on partitions to reduce storage needs.
  • Configure and administration of Business Objects Data Services
  • Ensured Databases are in compliance with HIPAA and SOX standards
  • Change Deployment using HP-PPM tool

Confidential, San Francisco, CA

Oracle DBA

Responsibilities:

  • Setup 3 2-node 10g RAC cluster databases, using ASM, OCFS2 on Linux-HP servers.
  • Create 15 Oracle 9i and 10g databases, support prod (and non-prod) upgrade from 9i to 10g
  • Setup data guard databases and perform failovers. In addition, setup Quest Shareplex replication for critical databases.
  • OEM setup and configuration.
  • Database tracing, database monitoring, OEM Setup, and RMAN backup configuration for oracle databases.
  • Setting up DBVault (database vault), ASO and Encryption for Oracle
  • Resolve Performance Issues in OLTP as well as data warehouse environments.
  • Applying CPU patches, documentation - DBA cookbook, mentoring Junior DBAs.

Confidential, San Francisco, CA

Lead DBA

Responsibilities:

  • Setup RAC using Sistina GFS on Linux/Oracle 9i and Data Guard with RAC. Implemented a 8 node RAC system, 4 databases, with Data Guard databases on 6 nodes. Use 10G Grid for monitoring the databases.
  • Implemented Data Guard Databases - one set lag behind by 6 hours (for recovering from accidental drop of data/objects), one set with zero data divergence.
  • Supporting production databases and as well as leading a team of 3 DBAs and 2 db developers.
  • Schema management and comparison, performance tuning, backup and recovery.
  • Setup high availability solutions like shareplex replication and standby databases.
  • Installation of Oracle 8i, 9i on Sun and IBM-AIX servers and database creation.
  • Trained in RAC setup and RAC tuning
  • Implement backups using netbackup, sqlbacktrack and IBM’s TSM and custom-made perl hot backup scripts(including RMAN). Implemented backup for databases over 100GB using SAN solutions.
  • Implement db monitoring(availability, tablespace monitoring, locking conflicts etc), using BMC Patrol, me/Watch and perl/shell scripts.
  • Troubleshoot application to database performance issues using scripts based on system tables, tools like Precise/Insight and Precise/Indepth, Quest Foglight and Spotlight.
  • Database design and programming, extensive use of oracle utilities like export/import, SQL*loader using direct/parallel mode.
  • Created Datawarehouse database and partitioned Objects implemented parallel DML

Hire Now