Data Manager
Resume:
Johnson Sheelam
732-***-**** / *******.*******@*****.***
Summary:
22+ years of extensive work experience on Oracle, SAP Sybase ASE, SAP Sybase Rep Server, MS SQL Server, MySQL, PostgreSQL and MongoDB Databases’ Development, Administration & Architecture.
Experience includes 18+ years of work as Architect, Designer and DBA handling mission critical VLDBs and 5+ years as Java Developer & WebLogic Admin for versions 5.1, 11g and 12c with middleware products OWB/ODI & OBIEE
Designed & Architected solutions for Oracle, SAP Sybase ASE, MS SQL Server & MySQL databases used for critical and high-available applications
5+ years of experience on Golden Gate replication tool for high volume database systems with ADG as source and its primary for DDLs, source being in AWS and target on premise.
DMA (Database Machine Administrator) of ODA X4-2 running Oracle 12.1.0.2.0 with 2 node RAC
Managed completed stack of Database (Oracle) and Middleware (WebLogic). Installation, upgrade and patching
Worked on data warehouse systems for building Dimensional models. Setup daily loads and configured query cubes through Oracle Warehouse Builder and Oracle Data Integrator for business reporting
Installed and configured complete stack of OBIEE
Extensive experience on Oracle RDBMS versions from 7.1.x to 19c
Design, implement physical and logical database models on ERWIN with forward and backward engineering and worked with ETL team for setting up loads through OWB, ODI and Looker
Extensive experience on SAP Sybase ASE versions 12.x to 15.x
Extensive experience with MS SQL Server versions from 2005 to 2019 with FCI and AlwaysOn
Extensive experience with MySQL from 4.x to 5.x with setting up instances on AWS
Architected for High Availability solutions like RAC, Active DataGurard, Streams replication, Golden Gate replication, Sybase Replication, MS SQL Server Transactional replication and database mirroring and MySQL replication for various RDBMSs.
Architected SAP Sybase ASE database setup for highly volatile business application. Designed solution includes VCS, SAP Sybase ASE and ZFS with snapshots and auxiliary node.
Architected as an interim solution for an application using MS SQL Server which is a mix of OLTP and DSS, this involves managing Isolation levels at session and database level.
Successfully completed multiple database migrations and consolidations
Install, setup, configuration and administration of Oracle Enterprise Manager Grid and Cloud Control.
Install, setup, configuration and administration of SAP Sybase Replication for MSA.
Architected and migrated ASE 15.7, 2 site MSA replication setup to VCS active-passive HA
Implemented virtualization through Delphix and VMWare for Database provisioning and refreshes
Configured ZFS snapshot backups with 3rd node as backup-only for highly volatile application consistency.
Installed and configured 12c multi-tenant Databases with Container database (CDB) and Pluggable databases (PDB)
Worked extensively on ASM, OCFS, ACFS, VCS Cluster File systems
3+ years of extensive work experience on Oracle security features including Transparent Data Encryption (TDE) and data masking and security wallet.
Strong experience in Performance Tuning. Successfully tuned projects by saving hours of implementation with query tuning
Performed Capacity Planning, Growth trend analysis and Prepared Reports.
Designed and implemented backup policies for most critical, zero down-time databases and automated cold and hot backups using Veritas NetBackup, Tivoli Storage Manager & BakBone NetVault & CA ArcServer.
Archived current databases to archival databases by using transportable tablespaces.
Implemented Flash back database / Flash back query / Flash back table features for faster fault recovery.
Restored & Recovered databases from data files of two different incarnations due to lost file systems by setting hidden parameters for recovery of critical data
Designed and implemented Disaster Recovery policies carried out DR exercises and successfully recovered databases from crashes.
Setup, configure and manage Oracle Message Gateway to interact with DB2 on Mainframes
Strong experience with Development and tuning of SQL and PL/SQL, database Procedures and Triggers,
Designed and implemented SOP for change control / Change management using Remedy, ServiceNow and TreamTrack through trouble tickets and OSR (Operation Service Request) and prepared technical documentation.
Technical Skills:
RDBMS Oracle 7.x through 12c, SAP Sybase ASE 15.x/12.x, MS SQL Server 2005 through 2014, MySQL 5.x/4.x, PostgreSQL 9.x
NoSQL MongoDB
Operating System Sun Solaris, HP-UX, RHE Linux, AIX & OEL, Windows 2003 through 2012
Hardware ODA X4-2, Sun M5K, NetApp Filers, Intel Servers
High Availability OPS, RAC, RON, DataGuard, BCV, SRDF, Oracle Streams, GoldenGate, Advanced Replication, VCS, MC-ServiceGuard, SAP Sybase Replication, MySQL Replication, MS SQL Server Transactional Replication, SQL Server clustering, Database mirroring
Virtualization Delphix, VMWare
Backup tools Veritas NetBackup, Tivoli Storage Manager Data Protection, BakBone NetVault, RMAN, MySQL Enterprise Backup (MEB), BCV, SQL BackTrack and CA ArcServer, AVAMAR
Monitoring tools OEM Cloud / Grid control, Sybase Central, Sybase Control Center, Grid Control Plug-ins for Sybase and MS SQL Server, Quest Spotlight, MySQL Enterprise Manager, BigBrother, Mercury SiteScope, Xymon System Monitor
Languages Java 2, PL/SQL
Tool / Utilities TOAD, DBArtisan, Erwin 7.3, Oracle Message Gateway
Scripting Language Shell Script, AWK, SED, Java Script
Configuration Management Serena, Mercury ITG
Incident / Change Management Remedy, ServiceNow, JIRA, TeamTrack
Web/Application Server WebLogic 5.1, 11 & 12, OWB, ODI & OBIEE
Certifications:
Oracle Certified Professional DBA (OCP) for 12c, 11g and 10g from Oracle University, USA
Oracle Certified GoldenGate 12c Implementation Specialist
Microsoft Certified Solution Associate (MCSA) for MS SQL Server 2012 Platform
Oracle Certified Professional DBA for MySQL 5.0 from Oracle University, USA
Oracle Certified Expert DBA for 11g R2/10g Real Application Clusters (RAC) & Grid Infrastructure
Administration from Oracle University, USA
Oracle Certified Expert DBA for 10g R2 Administration on LINUX from Oracle University, USA
IBM Certified specialist for PureData System for Analytics (Netezza) 7.1
Brainbench Certified Java 2 Programmer from Brainbench, Previsor Company
ITIL V3 Foundation level certified through APM / OGC
Education:
Bachelor’s degree in engineering
MBA in Financial Management & Operations Management
Experience:
State of NC, Dept. of Commerce-ESC, Raleigh, NC Sep 2012–Oct 2013 & Oct 2017-Current
Sr. Database and Middleware specialist
Database and Middleware specialist for tristate benefit compensation project involving Oracle 12c, MS SQL Server, ODI, OBIEE and Oracle Golden Gate
Installed and configured Oracle databases for standby with primary in AWS
Install and Setup Golden Gate 12301 / Microservices architecture from Standby database to Data warehouse using classic mine from active database which uses TDE
Configured GoldenGate between Active DataGuard and also in ALO mode due issues with unfixed OGG bugs
Upgraded GI and RDBMS from 11204 to 12201 on Solaris SPARC
Upgraded GI and RDBMS from 12101 to 19c (19.3.0.0.0) on LINUX
Setup and configure SSL for Oracle Database Listeners
Administer Quarterly switchover of primary/standby Oracle databases for patching.
Failover of oracle databases in DataGuard due to primary server loss.
Restore and Recover databases to PITR
Setup OGG fine-grained object replication based on source database architecture
Upgraded OGG from 12c to 19c
Troubleshoot Oracle Golden Gate EXTRACT and REPLICAT errors
Installed and configured OEM 13cR2 for enterprise monitoring and administration
Test and rollout quarterly patching of ASM, RDBMS, GoldenGate, ODI & OBIEE
Setup, configure and administer 2012 MS SQL Failover Cluster Instances
Setup, configure 2019 AlwaysOn Group server instances on AWS
Installed and configured middleware products Weblogic, ODI and OBIEE
Primary DBA Managing all Production, QA & Development databases in 24*7 environment running Oracle, MS SQL Servers on various operating systems
Setup and manage Oracle MGW queues to transport data between Oracle and DB2 on Mainframes
Run ETL using SSIS to extract data from CSV & text files and load into SQL Server for employer information
Design, create and manage physical and logical database models through ERwin including reverse engineering methodology.
Migrated databases from Non-ASM to ASM and vice-versa & Upgraded 10g databases to 11gR2
Setup and configure Real Application Testing (RAT) for upgrade from 10g to 11g. Applied one-off patch on source 10g database to have workload capture enabled.
Setup monitoring in OEM Grid control and manage warnings & alerts for all relevant Database metrics
Upgraded OEM & Agents from 13.2 to 13.4
TOAD for query management and basic database monitoring and Team Coding for version control and code management including code migration
Extensively worked on RMAN configuration, Block Change Tracking implementation and troubleshooting
Worked on partitioning of tables for data warehouse operations for achieving faster response time. Environment: Oracle 19c/12c/11g, Data Guard, ASM, Solaris 10, SLES, GoldenGate 19c/12.3, MS SQL Server 2016/2012/2008 R2 Cluster, ODI, OBIEE, SQL Loader, Oracle Message Gateway, IBM MQ Series, VERITAS NetBackup, RMAN, Erwin 7.3, TOAD, 10g Grid control, AVAMAR
Syngenta Crop Protection, RTP, NC November 2016 – June 2017
Database Administrator
Upgraded 11gR2 to 12c R2, converted non-CDB to CDB
Data Center migration of 8+ TB Oracle Databases
Install, setup and configure Big Data - MongoDB
Install, setup and configure PostgreSQL 9.x
Install, setup and configure MySQL 5.7.x
Migrated databases (Oracle 12cR2, MS SQL Server 2012) to local RTP Data center and AWS
Install, setup and configure EM Cloud control 13c
Install, setup and configure Oracle GoldenGate 11g & 12c
Scripting and setup backup jobs for Oracle, MongoDB, MySQL and PostgreSQL
Created Backup, Recovery and DR strategies and tested
Environment: Oracle 12c/11g, MySQL 5.x, PostgreSQL 9.x, MS SQL Server 2012, MongoDB, EM Cloud Control 13c, GoldenGate, RHEL
PNC Bank, Pittsburgh, PA Oct 2016 – Oct 2018
L4 Consultant for MySQL and Oracle clusters (Worked as consultant, task based)
Setup and configured, and administered 2+ TB MySQL database servers with multi-master replication
Two Bi-directional master replication with two DR replication servers
Setup and administered MySQL High Availability Manger (MHA) for switchover and failover
Installed and configured MySQL-multi to manage multiple MySQL servers on single host
Install, configure and setup relay log purge to retain last 12 hours
Install, configure and setup backups through MySQL Enterprise Backup (MEB)
Successfully completed restore and recovery of replicated systems of MySQL 4-way replication due to data corruption
Setup and configured, and administered 2+ TB MySQL database servers with multi-master replication
Two Bi-directional master replication with two DR replication servers
Recovered master due data corruption with backups from slave servers
Designed, coded and implemented MySQL account locking using connection_control.so, event and stored procedure as this feature does not exist as of MySQL 5.7
Designed and implemented TDE for MySQL replicated topology
Implemented SSL encryption for MySQL remote connections
Implemented MySQL utilities for setup, test, switchover and failover
Lead MySQL design effort for standardizing Bank wide implementation of MySQL databases setup including security hardening, auditing, encryption in transit and at rest
Designed, coded and implemented MySQL account locking using connection_control.so, event and stored procedure as this feature does not exist as of MySQL 5.7
Worked in LoB team for supporting Oracle and MySQL databases.
Completed many Oracle databases upgrade and datacenter migration to GF while working in LoB team
Upgraded Oracle 11.2.x clusters and databases to terminal release
Participate bi-annual Oracle patching for clustered and non-clustered 12c databases
Environment: Oracle 11 and 12c Cluster technologies, MySQL 5.6/5.7, RHEL, Solaris SPARC
Guardian Life Insurance, NYC, NY June 2016 – September 2016
Senior DBA consultant
Completed Enterprise User Security by implementing database authentication through Oracle Unified Directory.
Built databases for Guardian for its merged company through DBMS_DDL, datapump and RMAN.
Built Active DataGurad and setup SOP for completing these tasks
Worked with UNIX admins for setting Veritas Cluster for HA
Created SOP for cross-platform migration of Oracle databases from AIX to Linux
Upgrade databases through cross-platform migration (AIX to RHEL) along with upgrade from 11g to 12c
Successfully completed firm’s quarterly DR
Created purging scripts through shell, PL/SQL and SQL for databases based on retention period.
Setup cross-version GoldenGate for upgrade of Oracle 11g to 12c
Installed and upgraded MS SQL Servers to 2012 in AWS
Configured MS SQL servers in Idera and CMS
Managed SQL Server database mirroring and Transactional Replication
Setup ETL process through SSIS for transforming data from third party source into SQL Servers
Install, configure, administer Delphix 5.0 for database virtualization for development and testing purpose
Environment: Oracle 12c/11g Active DataGuard, GoldenGate 12.1, AIX, RHEL, TSM DP, MS SQL Server
2012, ServieNow & Control-M, Delphix
Daily Racing Form, NYC, NY November 2013 – May 2016
Senior DBA (Oracle, Sybase, MySQL & MS SQL Server) & CA ArcServer Backup Admin
DBA managing all Production, QA & Development databases in 24*7 environment running Oracle 12c/11g R2 with DataGuard, Sybase ASE 15.7 and Sybase Rep Server, MySQL 5.5.x with MySQL Replication and MS SQL Server 2005/2008 with Transactional Replication.
Installed and configured Sybase and SQL Server plug-ins to monitor Sybase and MS SQL Server databases through Oracle EM Grid Control
Migrated all RDBMSs (Oracle, SAP Sybase ASE, MS SQL Server & MySQL) to new Data Center and upgraded to higher versions.
Installed and configured Oracle GoldenGate for cross-platform data transfer from Sybase ASE 15.7 to Oracle 12.1(ODA)
Oracle Database EE:
Installed and configured 12c multi-tenant Databases with Container database (CDB) and Pluggable databases (PDB)
Designed solution based on application needs for Oracle, which involves Active DataGuard and RAC
Setup and configure Real Application Testing (RAT) to ensure smooth upgrade from 11gR2 DataGuard Setup to 12c RAC
Implemented Oracle Warehouse Builder (OWB) and migrated to 12c with separate Oracle Home as 12c does not support OWB, later upgraded to Oracle Data Integrator ODI.
Extensively worked on RMAN configuration, Block Change Tracking implementation and troubleshooting
Recovered database from block corruption and recovered accidentally deleted rows through flashback technology.
Rebuilt Standby database as databases was out of sync due to missing archive logs
Resource management configured using Oracle DBRM for optimum utilization of OS resources
Setup backup strategies and implemented RMAN, logical backups and Flashback feature to achieve fault tolerance. Scheduled backup jobs through RMAN
Configured various house-keeping jobs for alert log & listener log rotation and cleanup of old trace files
Setup monitoring in OEM Grid control and manage warnings & alerts for all relevant Database metrics
SAP Sybase ASE:
Install, setup, configuration and administration of SAP Sybase Replication for MSA.
Architected and migrated ASE 15.7, 2 site MSA replication setup to VCS active-passive HA
Architected SAP Sybase ASE database setup for highly volatile business application. Designed solution
Configured ZFS snapshot backups with 3rd node as for backup-only for highly critical application.
Installed, configured and administered Sybase ASE 15.7 and Sybase Rep Server 15.7. and upgraded Sybase ASE 11.9.2 to 15.7
Successfully recovered Sybase ASE server by rebuilding master database due to corruption caused because of secondary truncation point.
Troubleshoot Replication Server issues due to data inconsistency & route failures
Migrated database server from raw devices to file system through disk mirroring
Monitoring and Performance tuning through Quest Spotlight and sysmon utility for optimization of database performance
Sybase product license management
MySQL:
Installed, configured, administered MySQL 5.5.x and 5.1.x database servers.
Upgraded MySQL 4.x and 5.1.x to 5.5.x and 5.6.x
Designed MySQL fall back solution which includes replication and a fall back server in AWS with hourly snapshot refresh by connecting through AWS PEM authentication.
Installed LDAP for authentication of MySQL servers
Setup monitoring scripts for database server load with script to execute automated resolutions
Setup MySQL Replication on 5.5.22 database servers for HA
Extensively worked on Memory issues on different platforms like Solaris SPARC and Linux servers
Installed and configured MySQL Enterprise Monitor for databases
Extensive experience with various MySQL engines
Installed and setup multiple MySQL servers on one physical / Virtual host
MS SQL Server:
Installed, configured, administered MS SQL Server 2005/2008/2014 database servers.
Architected as an interim solution for an application using MS SQL Server which is a mix of OLTP and DSS, this involves managing Isolation levels at session and database level.
Setup up Transactional replication and database mirroring for HA
ETL through SSIS from flat files into SQL server also into Sybase ASE. Extract data from e-commerce database into excel by using data conversion to mask credit card info
Troubleshoot transactional replication issues
Upgraded databases from 2005 to 2008 R2 and 2014
Restore crashed databases on to different host through Copy/detach/attach and through CA Arc Server backup
Recovered databases from higher to lower version during Datacenter migration issues through SSMS task and generate scripts
Configured databases databases in CA ArcServer and TSM for backup and recovery
Successfully completed Datacenter migration project which involves modification of database architecture, cross-platform migration & Upgrade
Implemented Transparent Data Encryption at file level and column level
Performance optimization through SSMS execution plan management
Virtualization:
Created cloned copies of Oracle and Sybase ASE for Development and testing through Delphix
Implemented data masking for databases with sensitive data
Middleware:
Installed and configured and supported Oracle Weblogic 11g. Configured connection pools, access controls and deployment schedules
Installed, configured and managed complete stack of OBIEE
Setup IBM PureData System for Analytics for PoC, loaded data from Sybase ASE for testing
Environment: Oracle 12c/11g R2, Data Guard, RHEL, Solaris SPARC & Intel, Oracle Warehouse Builder
(OWB) and Oracle Data Integrator (ODI), Sybase ASE 15.7, Sybase Rep Server 15.7, Sybase
Control Center, MySQL 5.5.x, MySQL Replication, MySQL Enterprise Monitor, MS SQL
Server 2014 through 2005, Transactional Replication, Database Mirroring, SQL Server
Management Studio, Tivoli Storage Manager Data Protection, CA ArcServer, JIRA
Credit Suisse, RTP, NC March 2010 – Sept. 2012 & July to Sept 2017
Assistant Vice-President
Primary DBA Managing 40 Production, QA & Development databases for OLTP & Data warehouse
Setup strategies and prepare project plans for new projects’ upgrade and backup activities
Designed, Implemented, and maintained RAC & DataGuard on both ASM, OCFS & VCS
Installed 11g RON, RAC and created databases for 11g on RHEL/SLES Linux & Solaris
Upgraded RAC & SI databases from 9.2.x to10.2.x to 11.1.0.7 and from 32 Bit version to 64 Bit on RHEL & Solaris, also converted databases from 64 Bit to 32 Bit version.
Upgraded databases across platforms (Solaris to Linux) of 10+ TB to 11202 through downstream capture using staging database
Migrated databases from Non-ASM to ASM and vice-versa
Configured databases for Transparent Data Encryption (TDE) with security wallet
Configured database encryption for backups (RMAN and Data pump) and used encryption wallet and master key for security
Configured SSL encryption for listeners and data in motion
Used data masking for certain sensitive column data while transferring to non-prod databases.
Co-ordinate with UNIX SAs for configuring Databases in Active-Passive cluster through VCS and DR through BCV & SRDF. Carried out quarterly testing of cluster failover and DR failover through SRDF
Partitioned tables based on range, list & hash methodology. Used dbms_redefinition & exchange partition
Planning, implementation and reclaiming databases through Disaster recovery by implementing quarterly DR exercises
Capacity planning for existing and new databases for Database size, CPU and memory
SAP Sybase ASE Administration
Server security administration of logins, users, roles, access
Sybase ASE server backups and restoration, database backup and copy to Dev/QA servers
Troubleshoot performance, blocking related issues for optimal performance
Install and configure Sybase ASE 15.x on UNIX servers
MS SQL Server:
Installed, configured, administered MS SQL Server 2005/2008/2008 R2 database servers.
Setup up Transactional replication and database mirroring for HA
Performance tuning through SQL profiling
New Server and Database build and refreshes
Support day-to-day activities – Users requests, cloning, creation of new objects, modification to existing objects, code migration and data load etc.
Environment: Oracle 11g/10g, ASM, VCS, OCFS, Sybase ASE 15.x, Solaris, RHEL, SLES Linux, BCV, Veritas NetBackup, RMAN, RAC, Oracle Streams, SRDF, SQL Server 2005/2008/2008 R2
YBP, Contoocook, NH August 2008 – March 2010
Sr. DBA
Managed 35 Production, QA & Development databases for OLTP & Data warehouse of 800+ GB in 24*7 environment running Oracle 11g/10g on RHEL and Windows servers.
Configured database encryption for backups (RMAN and Data pump) and used encryption wallet and master key for security
Used data masking for certain sensitive column data while transferring to non-prod databases.
Designed, implemented, maintained RAC & DataGuard ASM, OCFS & File systems (ext3 & NTFS)
Converted SI database instances to 2-node RAC Instances through manual process and “rconfig”
Maintained databases at the latest patch level by applying quarterly CPUs and one-off patches. Applied patches in rolling manner to reduce downtime of cluster databases.
Installed, configured MML BakBone NetVault server and client software & RMAN plug-in.
Setup backup strategies scheduled backup jobs through RMAN, BakBone NetVault(MML) & Datapump
Worked on 11g feature of “Active duplication” to duplicate databases which eliminates need to have a RMAN backupset
Worked with storage team for better implementation of NetApps storage devices for optimum performance
Implemented 11g secure logon, secure wallet, dump file encryption, tablespace encryption & RMAN backup encryption for added security
Worked on partitioning of tables for data warehouse operations for achieving faster response time. Partitioned tables based on range, list & hash methodology. Used dbms_redefinition & exchange partition
Worked with CTX preferences, stop lists, word lists to create and maintain domain indexes for enhancing text-based search
MS SQL Server:
Installed, configured, administered MS SQL Server 2000/2005/2008/2008 R2 database servers.
Setup up Transactional replication and database mirroring for HA
Troubleshoot transactional replication issues
New Server and Database build and refreshes
Upgraded databases from 2000/2005 to 2008 R2
MySQL:
Installed, configured and administered MySQL 4.1.x database servers.
Upgraded to MySQL 4.x
Configured database backups through mysqldump and cloned to non-prod servers.
Database tuning through my.cnf configuration parameters
Extensive experience with various MySQL engines
Installed and setup multiple MySQL servers on one physical / Virtual host
Documented technical processes and set up SOPs
Environment: Oracle 11g/10g, ASM, OCFS, RHEL, Windows 2003 Enterprise & Datacenter, BakBone NetVault 8.2/7.4.5, RMAN, RAC, DataGuard, 10g Grid control, NetApps storage, MS SQL Server 2005/2008
Johnson & Johnson, Raritan, NJ March 2007 – July 2008
Sr. DBA
Primary DBA for 65 Dev & Production databases for Data warehouse & OLTP environment running Oracle 11g/10g/9i/8i/8 on HP-UX and Windows servers.
Setup strategies and prepare project plans for new projects, upgrade and backup activities
Involved in setting up and implementation of SOX and IAPP policies as per FDA guidelines
Schedule backup and monitor jobs through Tivoli Workload Scheduler
Installation, patching and upgrade. Upgraded from 8i to 9i then to 10g also directly from 8i to 10g.
Database security and one-off patching through Opatch utility
Lead DBA for Datacenter consolidation project for consolidating Johnson & Johnson’s 3 Data centers
Analyzed various tools and methods for best use in Data center consolidation. Used IBM’s TDMF for replication at file system level (with alternatively presenting same SAN arrays for cut-over and cut-in processes) and RMAN Duplication of databases at database level
Designed, implemented, maintained RAC, MC ServiceGuard and Oracle DataGuard on ASM, OCFS and file systems
Developed shell/AWK scripts to automate database backups for user initiated, BCVs and RMAN directly to tape through Veritas NetBackup interface. Extensively worked on RMAN implementation and troubleshooting
Capacity planning for existing and new databases for size, CPU and memory
MS SQL Server:
Installed, configured, administered MS SQL Server 2000/2005/2008 database servers.
Setup up Transactional replication and database mirroring for HA
User and Login management
New Server and Database build and refreshes
Upgraded databases from 2000 to 2005
MySQL:
Supported MySQL server databases for Installation, backup, restoration, trouble shooting
Installed, configured, administered MySQL 4.x database servers.
Configured database backups through mysqldump and cloned to non-prod servers.
Setup monitoring scripts for database server load with script to execute automated resolutions
Extensive experience with various MySQL engines
Installed and setup multiple MySQL servers on one physical / Virtual host
Environment: Oracle 11g/10g/9i/8i/8, ASM, RAC, MC Service Guard & Data Guard, HP-UX, Windows servers, Veritas NetBackup, HP-Omni backup, BCVs, RMAN, MySQL 4.5, MS SQL Server, TWS, EM Grid Control
COLT Telecom Group Limited January 2005 – January 2007
Sr. DBA
Installation, patching and upgrade of Production databases of size varying from 350 GB to 3.2 TB. Upgrade many instances from 8i to 9i then to 10g.
Logical and physical design and implementation of databases
Designed, Implemented and maintained RAC, MC ServiceGuard and Oracle DataGuard
Improve database performance through tuning Oracle, and server resources like CPU and memory
Capacity planning for existing and new databases for size, CPU and memory
Managed version control through Serena (Change Management tool) and Mercury ITG (Configuration tool)
MS SQL Server:
Installed, configured and administered MS SQL Server 2000/2005 database servers.
Performance tuning through SQL trace and profiling
New Server and Database build and refreshes
Upgraded databases from 2000 to 2005
Environment: Oracle 10g/9i/8i/8, RAC, MC ServiceGuard, HP-UX B.11.11, Linux 2.4.9, AIX 5.1, RMAN,
SQL BackTrack, Veritas NetBackup, PL/SQL, MS SQL Server
General Motors Corporation, USA thru EDS July 2001 – December 2004
Oracle DBA
Successfully administered 22 Production, 66 Pre-Prod & ITL (Integrated Testing Lab) and 2 SDM servers in 24*7 environment
Installed and administered databases in OPS/RAC and HP-ServiceGuard architecture
Logical and physical design of databases, Patching and upgrading of databases
Cloned and refreshed databases from Prod to Dev through both logical (exp/imp) and physical refresh (restoration, recovery and control file recreate) methodology
Developed backup strategies for databases and implemented RMAN backups to disk and also directly to tape through Tivoli Storage Manager. Implemented BCV backups for large databases.
Tuning of Oracle memory, UNIX server CPU and memory for better performance
WebLogic administration for versions 5.1
Environment: Oracle 8i/9i, OPS/RAC, RMAN, BCV, Solaris 8, HP-UX, Weblogic, Tivoli Storage Manager.
Sun Microsystems, Newark, CA, USA Nov 2000 – June 2001
Sr. Backend Developer Oracle/Java/Sybase
Carried out requirement analysis and system study. Member of BPR team for setting up existing business flow to system and project design.
Implemented MVC architecture of J2EE’s model-2 by using Java Beans, JSPs and Servlets and developed Environment: Java Servlets, JSP, Java Beans, Java Script, Sybase 11.0, Solaris 7.0
GOETZE GmbH June 2000 – Nov 2000
Backend Developer/DBA Oracle/Java
Developed and implemented the project in WebLogic 5.1.0
Installed and configured Oracle.
Logical database design and data modeling. Developed Oracle procedures, functions and triggers.
Query optimization, table re-organization and logical backup of frequently updated tables
Used XML for updating data at client side in preparing production plans and SQLJ for retrieving the data from the Oracle 8i and displayed in JSP (Presentation layer)
Implemented MVC architecture of J2EE’s
Contact this candidate