Sr. Staff Database Planning Engineer Resume
2.00/5 (Submit Your Rating)
AustiN
SUMMARY:
- Over 15 years of IT experience & 10 years in Oracle Database Technologies, served clients such as Confidential, Confidential, Confidential , Confidential - Confidential , Confidential & Confidential .
- Experience in implementing database high availability solutions & excellent communication ability to explain a technical problem to management, team player. Shares knowledge & coaches team members. Ability to work on high performing teams and deliver under pressure situations.
- Architecting & building Cassandra ring cluster in Multi data centers. Having experience in Benchmarking & Assessing Throughput capacity. Planning the storage, network requirements & configuring recommended cassandra.yaml parameters, JVM settings & index management. Cassandra certified in Architecture, Installation, Administration & CQL.
- Experience creating data-based solutions on a distributed platform with Hadoop, and Cassandra. Worked on Cassandra builds & stress testing applications to migrate from Oracle to Cassandra. Scaling the Cassandra cluster, by adding nodes & as well removing nodes.
- Having sound Operational experience of all aspects of Cassandra performance tuning/monitoring components like OPS Center, nodetool, Keyspace stats Monitoring, JVM tuning, rebalance, add/remove nodes, monitoring Keyspaces and column families wait events & enabling tracing on request.
- Worked extensively on Cassandra installations, troubleshooting & administration.
- Log file monitoring & strategizing the compaction process, choosing the compaction method to adopt. Debug queries and performance issues, Network issues. Experience in Integrating Cassandra with Hadoop, using Cassandra File system.
- Worked on Cassandra Pre-post implementation activities i.e. POC, production make ready & architecting the solution to migrate an RDBMS Oracle application to Cassandra platform.
- Expertise in Deployment and Support of Cassandra in Multi-Data Center / Multi Region setup. strong understanding of the Cassandra data model and architecture, configuration of a cluster. well versed with complex inner workings of Cassandra, such as the gossip protocol, hinted handoffs, read repairs, Merkle trees and Staged Event-Driven Architecture (SEDA).Strong understanding replica Placement Strategies, Partitions, Snitches, Dynamic Ring Participation and Security with in Cassandra.
- Over 14+ years of experience on Oracle Database servers on 10g, 11gr2, Ebusiness Suite, Golden Gate on leading the projects in Architecting the Database solutions, implementation, migrating & supporting production environments of Oracle RAC, Golden gate & Ebusiness suite, & Exadata.
- Having sound understanding of Oracle RAC & Clustering technologies, RAC implementation, Cluster Health Monitoring & ASM implementation & support.
- Architecting Golden gate Solution (XAG), HA setup in RAC environment as well supported Golden gate in production environment. Well versed with Golden Gate replication setup in Activie-Active, GG HA configuration & production support.
- Experience in supporting SYBASE, MY-SQL & SQL SERVER environments & integrating/setting up replication between heterogeneous environments.
PROFESSIONAL EXPERIENCE:
Confidential, Austin
Sr. Staff Database Planning Engineer
Responsibilities:
- Worked on architecting Cassandra Database solution to migrate from Oracle to Cassandra.
- Extensively worked on planning the migration, data transfer, data modelling
- As a DB engineering team lead, Architected & implemented Oracle RAC for b. providing pro-active maintenance support, handling performance tuning issues, analysis, as well supporting the Golden Gate replication / configuration activities.
- Worked extensively on performance tuning of the database, RAC, Golden gate replication setup between the HOT-WARM & DR sites, Benchmark testing of the environment.
- Completed successfully Data center Migration & DR project of financial applications which involves migrating multiple databases from Solaris to Linux as well successfully completed DR Failover from one Data center to another.
Confidential, Irvine, CA
Oracle DBA
Responsibilities:
- 4 years of implementation, supporting & administration of Oracle Real application Clusters & Oracle Database Servers for Confidential client on for their various Web Application, Engineering Projects in Oracle ebusiness suite on 11i, R12 & 10gr2 11gr2 environments. Having excellent project management & documentation, presentation skills, leading the Database team.
- supported production servers of MS-Sql server & Mysql for Engineering Applications.
- Successfully completed 11.5.10.2 upgrade project, 2 tera byte database on 2 node Sun Solaris server
Confidential, Plano, TX
Oracle Apps / RAC DBA
Responsibilities:
- As Consultant DBA, supporting & implementing Oracle Ebusiness suite & implementing 4 Node 10g RAC & 10g OEM - grid control which is serving Data warehousing, BPEL servers, as well as multiple production databases on SUN Serves.
- the job role is to administer the RAC databases, Upgrading RAC, patching, Migrating 11.5.9 database to OATM, cloning using Rapid clone attending to user / development team requests, & installations, pro-active monitoring of Database health, ASM Storage Administration, Data guard setup & Maintenance.
- Supporting the 24 x 7 Oracle cluster environment Databases, which are hosting Dataware Housing, Oracle ebusiness suite 11.5.9, 11.5.10, Oracle Database Server 10g on SUN Solaris platform, which are controlled/monitored thru the 10g OEM grid control.
- Working on the project to migrate the existing Database servers to RAC environment and performing the maintenance / health check of the database, troubleshooting the day-to-day issues, reporting to the Team Manager about the new developments, / requirements of clients/Development team that comes up and implementing the same as per the given maintenance window.
Confidential
Senior Consultant Oracle Apps DBA
Responsibilities:
- Oracle Applications Database upgrade from 8.17 to 9.2.0.5 & Technology Stack Upgrade for Hatsun Agro Products.
- Implementation & Maintenance Project for 24x7 Confidential ., Confidential
- 11.5.5/11.5.6 to 11.5.10.2 upgrades on AIX UNIX for Confidential, Confidential, Confidential, Confidential .
- Working with clients for the new project initiatives/Leads, leading the on-site dba’s, responsible for the activities/recruiting on-site DBA’s, reporting to the Management about the project progress.
- Providing consulting to clients on server selection, sizing, project planning & implementation.
Confidential
Oracle Apps DBA
Responsibilities:
- Cloning, Patching, and Administering the Concurrent Mangers
- Troubleshooting the user issues, interacting with the end users/ coordinating between development team / Users to carry out the Patching/ implementing new changes to the system. Leading the DBA Team.
- Applying patches on production servers
- Periodically cloning the production server on to UAT / DR server.
- Proactively applying the patches on Oracle Database as well as on ebusiness suite server.
- Documentation of any issue and technical activities
Confidential
Oracle Apps DBA
Responsibilities:- Maintaining the production servers of Oracle APPS 11.5.5, Cloning, Patching, Concurrent Manager Admin, User Creation and assigning of responsibilities, using various AD Utilities for Application Maintenance, & day to day monitoring.
- Regularly monitoring I/O, Disk Usage patterns, & observing Alert Log files & Trace Files and configured Clustered Database on SCO-UNIX with Reliant cluster ware, thru with RAC concepts and installation.
- Conducted corporate training to Confidential employees on oracle 9i database.
