Senior Dba (ssme) Resume
2.00/5 (Submit Your Rating)
EXPERIENCE SUMMARY:
- Associate with Confidential since last 10 years in different capacities such Team Lead, Senior DBA and having a total experience of 12 years in IT industry as production DBA and supported huge Telecom production setup (24*7) like Sprint, Metro PCS, COMCAST ORION,MODESTO, ALTICE, Cable Vision.
- Main area of expertise is as an Oracle 9i/10g/11g/12c database administrator.
- Oracle Certified, Professional.
- And Having expertise in Casandra and Couch base NoSQL DB ‘s in Production environment.
- Managing and coordinating team in 3 geographic location on shore (USA), off shore (India). Attending Meeting with client and coordination with application team for current project and future Business development. Involved in provide Estimate and design suggestion for various implementation project.
- Expertise in setup/configuration/management of Oracle Grid Infrastructure - RAC, ASM, Active- Passive, Active-Active cluster
- More than 12 years of experience as Oracle DBA, provided frontline DBA support for 24X7 production, testing and development support on Multi-terabyte 12c/11gR2/11g/10g/9i RAC and Non-RAC databases. First stabilizing critical and/or deteriorating situations then working toward permanent self-sufficiency, stability, and maintaining defined/expected service levels.
- Expertise on Oracle Active Data Guard, Partitioning, ASM, Performance Tuning.
- Hadoop Cluster Administration.
- Strong organizational skills and excellent ability to communicate effectively with both technical and business clients.
- Expertise knowledge on Couchbase cluster configuration, setup, backup and recovery, Bucket Management.
- Used Goldengate for Standby Creation and Standby DB’s are syncing with Golden Gate. Helpful to Switch to DR without any down time.
- Hadnling DR-DRILL activity and performing DB Failover and Switch over.
- DDL + DML replication using Golden Gate
- Production setup of Cassandra Multi DC setup.
- Expertise knowledge of NoSQL DB’s and architecture.
- Expertise on Oracle Migration.
- Cassandra Implementation using DataStax.
- Exposure to support and manage very large databases with heavy OLTP and batch activities on 24/7 support env.
- Expertise knowledge on Cassandra cluster configuration, setup, backup and recovery.
- Implemented Couchbase XDCR setup as a Disaster recovery solution.
- Excellent knowledge in RMAN, Conventional Backups/Recoveries (BCV, Data pump)
- Hands on experience of configuring and administering Oracle Data guard, Standby Database, partitioning and compression.
- Multitasking credentials with excellent planning, execution, monitoring skills, as well as the ability to handle multiple tasks in high pressure environments under tight deadlines.
- Good knowledge and experience in Performance monitoring and tuning activities.
- Articulate communicator with strong analytical and interpersonal skills, known for honest, efficient work ethics and delivering projects on time without compromising on quality.
- Good experience on OEM Grid control, DB console.
TECHNICAL SKILLS:
Operating Systems: HP-Unix, Sun Solaris, Windows 2000.Linux
Langages/Technologies : PL/SQL, C, SQL
Databases: 9i,10g,11g,12c, Couchbase, Cassandra
Oracle Tools: Oracle Enterprise Manager, Data guard, TKPROF, EXPDP, RMAN, Toad. Golden gate, Shell scripting.
Domain Knowledge: Telecom, Banking.
No SQL Tools: Nodetool, Cassandra stress, pillowfight, cbq, cbworloadgen,cbstats, Attunity
ENGAGEMENT DETAILS:
Confidential
Senior DBA (SSME)
Responsibilities:
- Implementation and support Oracle Real Application Clusters (RAC), Including installing cluster ware, ASM (and shared disks) and creating new databases.
- Project planning and designing involving Database changes/activities
- XDCR setup of Couchbase
- A deep understanding of Cassandra design principals, cluster connectivity, security and the factors that affect distributed system performance
- Golden Gate setup as replacement of Active Data Guard for COMCAST ORION production DB’s as part of RT060 .
- Responsible for planning major maintenances, upgrade and migration activities
- Provide support for about 150+ OLTP and Non- Production databases sizing from few GB’s to multi terabytes
- Setup and manage different tools for effective Database Monitoring and Performance tuning like - OEM
- Couchbase Installation, Setup, Cluster configuration, Backup and Recovery.
- Setup Multi DC environment for Cassandra.
- Cassandra Installation, Setup, Cluster configuration, Backup and Recovery.
- Grid control, Self-written scripts, OVO Monitoring, Oracle utilities like OS watcher, recheck etc.
- 8 node Hadoop Installation and Administration.
- Install and Maintain Oracle 12c and 11g Grid Infrastructure setup including RAC (Active/Active) and Active/Passive setup
- Enabled Cassandra monitoring using JMX.
- Setup and maintain Oracle Golden gate software for real time data integration and replication in heterogeneous IT environments Also used GG for one of the major migration of in-house application from one version to another with almost zero downtime
- Performed Stress and Performance testing to benchmark the Cassandra cluster.
- Configure RMAN backups with HP OMNI Tape backups and performed complete/incomplete recoveries
- Administering and troubleshooting Oracle times ten In memory database
- Involved in various conversion activities Getting data from legacy system to Confidential platform
- Configure/Setup Data guard, Active Data guard for real time database replication between PROD and DR and switchover/failover testing
- Integrate operational processes including Incident, Problem, Change and Issues Management
Confidential
DBA Team Lead
Responsibilities:
- DB installations and upgrades, storage allocation, DB application structures changes, maintaining system security, first level backup and recovery for non-production environments.
- MYSQL DB Production Support and Monitoring
- Promote team quality assurance and task cross all activities; Review code/scripts/plans, meet KPIs ad SLA, plan vs. Actual comparisons and LL/RCAs.
- Preparing deployment plan, shift schedule coordinating with all team member, task assignment monitoring, review.
- Identify automation and efficiency opportunities, lead and direct the solution creation and implementation, and assure standards (new and existing processes and initiate enhanced changes).
- Manage and lead Root Cause Analysis, Lesson Learned and prevention processes to meet high standard of deliverables and work according to company methodology.
- Golden gate setup and troubleshooting. Designing Extract Pump and replicate to reduce any Lag.
- Coordination with clients which includes understanding/ gathering requirements (storage /database/budget), supporting vendor installation, resolution of problems and providing database solutions in a timely manner.
- Attending meetings with customer to discuss about current issues and defects in production and give ETA/updates for them.
- Attending meeting with roadmap teams to formulate the Migration roadmap for each Market.
- Implementation and support Oracle Real Application Clusters (RAC), Including installing cluster ware, ASM (and shared disks) and creating new databases.
- Estimating and Validating Hardware & File system requirement & reviewing high level and detailed designs for future releases.
- Attending meetings with customer to discuss about current issues and defects in production and give ETA/updates for them.
- Attending meeting with roadmap teams to formulate the release roadmap for each release.
- Designed a proof of concept environment to facilitate functionality testing and features, built a pilot environment which mirrored production to do in depth testing for all customers, and provided a detailed migration plan to migrate the current production cluster to the new environments.
Confidential
Senior Database Administrator
Responsibilities:
- As a Database Administrator (with a team size of 10) is involved independently in the Leading team of DBA supporting Oracle 9i/10G/11G database support for Core Banking database of Confidential BANK.
- Coordination with clients which includes understanding/ gathering requirements (storage /database/budget), supporting vendor installation, resolution of problems and providing database solutions in a timely manner.
- Maintaining Oracle Database, Applying Patch.
- Database Installation, Upgrade, Applying Security Patches
- SQL optimization for Application / Reporting Tuning
- Oracle DB Hardening based on Security protocols defined with Customer
- Oracle TDE Implementation
- Data guard setup and monitoring
- Worked on Oracle Database migration project - HPUX to Linux using RMAN & Data pump utility
- Support Confidential Release activities end to end from Delivery to Production rollout
- Preparing DBA Handbook - Documentation of day to day task
Confidential
Database Administrator
Responsibilities:
- Performance tuning
- Installation and configuration of Oracle Databases
- Creation of databases
- Maintenance of physical files
- Managing RAC Instances
- Day to day monitoring
- Patch application
- Backup and recovery
- Periodically creation of clone databases.