SUMMARY:

• I have over 10 years of RDMS and more than 13 years of total IT experience, with thorough knowledge of Software development Life Cycle (SDLC) in large - scale, high-volume enterprise environments with various applications and systems skills supporting sterling commerce and other core businesses. Analyze, test, and implements physical database design to support various business applications (including base definition, structure, documentation, long-range requirements, operational guidelines standards for best practices).
• I lead and provide high degree of coordination between users, technical, application, and corporate entities to ensure effective data management as a corporate enterprise. Represent DBA group in weekly change management meetings, where all planned production changes is approved prior to deployment. I have willingness to work with customers of varying levels of technical expertise in high-pressure, complex environment, with a thorough knowledge and configuration of interrelationship between oracle and non-oracle databases to ensure uniformity across IT systems infrastructure and enable effective application integration capabilities.
• As production support DBA responsible for managing development, test, stage, training and critical production database environments. I have good working real time experience in ASM, ACFS, Golden Gate, RAC and DataGuard with standby technology for FSFO in Oracle 9i, 10g, 11g and 12c with different configuration, creating multiple node RAC database and management. Also responsible for creating processes and developing Shell scripts that improves proactive monitoring of database performance, availability and security. I am responsible for monitoring the databases, identifying problems and providing quick, efficient remediation, as well as performance monitoring, also, follow all standards, policies, procedures and security requirements for best practice of the IT department and the DBA team
• Ensures data recovery, performance tuning, maintenance, data integrity, and space requirements for both physical and logical databases are met through formulations and monitoring of policies, procedures, and standards relating to database management best practices. Also Document and perform system upgrades, application updates, and define monitoring requirements based on customer’s business needs.
• Experience in isolating, diagnosing and resolving DBMS problems, including root cause analysis and working with Oracle advanced features such as RAC, Partitioning, Streams, OEM, Cloud Control (knowledge with upgrading OEM from 11g to 12c and 13c), Also, experienced with Various Database upgrades and data migrations, from lower to higher versions (oracle 9i, 10g to 11g and 12c) and across platforms (Mysql to Oracle, MSSQL to oracle, Postgresql to Oracle and more). Proficient in database/server consolidation, data center migration and Disaster Recovery solutions with some years of MongoDB scaling across data centers and in-depth knowledge of MongoDB HA strategies including replica sets.
• Experience converting business requirements into technical database specifications, utilizing latest Oracle & SQL Server features, ensures solutions meet business objectives, establish and maintains high level of user trust and confidence in my knowledge of and concern for users’ business needs. I Serves in 24/7 Production supports, document and providing technical supports to applications administrators, developers, business analysts, software engineers and other IT experts in addition to managing highly customized database environments and provides emergency on-call supports with hard work, lots of team efforts, and strong ethics.
• Installation, cloning and maintenance of Oracle products in HA configuration: Oracle EBS suite (11i, r12), Oracle SOA suite (11g), Oracle DISCOVERER (11g), Oracle OAM/SSO (11g), Oracle RAC (11g), Oracle OBIEE (11g)
• Expertise in Cross platform Migration of Oracle products (Same / Different Endian Formats) from HPUX to Linux, Windows/AIX to Linux. Etc. with minimal downtime

TECHNICAL SKILLS:

• Oracle 9i
• 10G
• 11G
• 12C
• 13C
• Oracle Business Intelligence (OBIEE) 10.1.3.4
• 12c (12.2.1.0.0 )
• Oracle Financial Application (11.0.3
• 11.5.4- 11.5.10
• R 12.0.6 -12.1.3
• 12.2.4) Web logic
• Fusion Middleware
• MSSQL Server 2012/2008/2005/2000
• MySQL 5.1-6
• PROs Apps
• Splunk
• RAC
• DataGuard
• RMAN
• ASM
• Postgres
• Mysql workbench
• Veritas Netbackup
• Oracle OEM and Cloud Control
• Linux
• AUX
• HP-UX
• VMware
• EMC Storage
• HP-Storeonce
• Toad for Oracle
• Toad Data Point tkprof
• Glassfish
• Moberxterm
• Super-putty
• Redgate
• Websphere console
• IBM Master Data Management
• Idera Tools
• SQL Server Profiler
• BMC Remedy
• Dbvisualizer
• Robomongo
• MongoVue
• Mongochef
• Management Studio
• SQL Developer
• Datastage Clients
• SqlTools
• WinSQL
• WinSCP
• Filezilla
• TightVNC
• Zabbix
• Glances
• Ansible Automation tool
• Hadoop
• Exadata.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Database Administrator

• As 24/7 Production supports DBA, Providing technical supports to applications administrators, developers, business analysts, software engineers and other IT experts in addition to managing highly customized database environments and Provides emergency on-call support on schedule Rotations.
• Troubleshooting and performance resolution experience in managing highly available, transactional databases with a large volume data set and Proactively monitor database performance and tuning, analyze performance indicators, recommend and implement improvement actions
• Install, configure, creates and maintains database and objects and manages architecture, interconnections, schemas for the storage with practical understanding of physical structure, overall architecture, and database performance analysis on Oracle 9i, 10G, 11G and 12C on various distros, which include: RedHat Linux, Oracle Enterprise Linux, AIX, HP-UX, Solaris Etc. for development, staging, QAT, UAT, testing and production environments.
• Monitor and analyze system performance, tuning and optimization of Database engine and hardware, including SQL statements using scripts, Oracle Statspack, SqlT, Oracle trace, TKPROF, Automatic Workload Repository (AWR), ADDM, OEM/Grid Control, Toad, RDA and other Oracle tools for performance analysis.
• Oracle Database Migrations from 10 to 11g and 12c, Patching and Various Upgrades including migration of Database Flatfile system to ASM with minimal downtime including cross platform migration with TTS
• Maintain databases by patch applications and enhancements/upgrades of environments and Automate routine maintenance tasks using standard scripting practices
• Troubleshooting and Solve non-routine problems and determine the best solution through cost/benefit analysis also Improve efficiency and quality of delivery by automating routine tasks.
• Work with other teams within operations and peer groups like Development, QA, Apps admin, Web Admin as a lead and/or member, including IT Server Management, Storage Admin, System Admin and other groups and make sure that all events, incidents and problems are resolved as per the SLA.
• Contribute to best of breed product support tools including run books, monitoring, and knowledge bases to aid in the product support process, suggest improvements to existing processes/tools used and implementation ideas.
• Enforce best practices in all areas of database administration and architecture, including Formulates, documents and monitors policies, procedures, security and standards relating to database management. (E.g. system security policies in accordance with SOX, backup and archiving procedures, User access managements etc.)
• Working with ETL tools to manage projects e.g DataStage and other responsibilities
• Lead onsite and offsite team of experts to successfully upgrade IBM WPC/MDM 5.3.2 to 11.4. for both applications and Oracle Database Instances, then troubleshoot and resolved integration flows across systems
• Streamline operational/production DB support tasks including backup/recovery, user rights provisioning, index re-orgs, process monitoring, query optimization for better performance etc.
• Manages and supports various backup and recovery strategies for Oracle databases which are tested and validated on a quarterly basis (using RMAN, Export/import, Standby databases etc.).
• Assisting with PeopleSoft, Sterling Order Management, IBM Master Data Management, Data Warehouse and manages Web and App server on these systems as applicable.
• Plans and implements new technologies and major releases deployments for the most critical enterprise-wide IT infrastructure projects. Tests, installs, and migrates software, patches, upgrades, proxies, applications, and/or hardware.
• Assisting with MSSQL, Informix, PeopleSoft, Postgres, PROs, Mysql and MongoDB Databases. Activities includes Installation, configuration, maintenance and their administration, Users access managements, Deployments of SQRW in PeopleSoft, Data migration among DEV, QAT, UAT, test and production, performance tuning, Purging, Script to automate processes, Backups, Disaster recovery and restores.
• Configured from the scratch, Multiple Nodes Oracle RAC, Multiple nodes Sqlserver 2012 Cluster and manage them for productions, HA and Disaster Recovery
• Maintain MongoDB instances and infrastructure for a massive, high-throughput transactional system and Troubleshoot performance optimization in MongoDB for customers
• Configure and monitor numerous MongoDB instances and replica sets, Backup and restore procedures for MongoDB databases using various backup strategies, Automate routine tasks with scripts and open-source tools
• Experience in performing Mongo DBA operational routines in following areas: Configuring and monitoring replica sets, Optimizing database/query performance, Configuring Sharding, monitoring, and identify the proper shard key, Selection and inserting large amounts of data, Performing Security measures, backups and restore backups, User Management - creating users, assigning roles, managing permissions in MongoDB
• Manages over 5 TB MongoDB installation of standalone and Replica and upgrade from MongoDB 2.6 to 3.0 with modern storage engine of WiredTiger which save more than 50% of Hardware space used
• Lead other IT team to successfully migrate DBs across Systems (Postgresql, Mysql and Sql-Server to Oracle)
• Assist with implementation of the backup strategy and the testing of Disaster Recovery processes of Databases
• Installation, configuration and full setup of ASM/Flat file system and installation of Oracle databases
• Setup OEM and Oracle Enterprise Manager Cloud Control 12c, 13C to manage database instances, services etc.
• Perform problem escalation to the development team and third parties including resolving issues with vendor support via Service Requests e.g Oracle Service Requests (SR) submission, resolution and management., PMR with IBM etc
• Assist with implementation, release of database changes/Code migrations as submitted by the development team after change control management committee approval.
• Provides leadership and expertise in investigation and resolution of performance related issues for environments.
• Implement database structures to ensure appropriate levels of performance, data- integrity, recovery and security
• Implements improvements to process and code used for automating maintenance and operational tasks in various systems including critical trading systems, warehousing systems and other system

Confidential, Atlanta, GA

Lead System Database Administrator

• Participates in the project feasibility process and defines the database infrastructure to fulfil the project requirements and advises on overall database design, development and implementation of complex database environments that exist across all platforms
• Design/Implement/Support Oracle Goldengate Replication from end to end and manage key database releases for DEV, QA, UA, Production and DR as part of the overall SDLC.
• Configured from scratch, Oracle muti-nodes Real Application Cluster (RAC), Data Guard with standby and Observer, maintained and managed them for high availabilities for multiple clients
• Installed MySQL, MariaDB, MongoDB and Oracle DBs (10g/11g/12c as per customers’ specification
• Design, and implementation of Oracle 10G, 11G, Oracle ASM, Oracle11GR2 Real Application Cluster (RAC) with FSFO Observer, Oracle Applications 11i, Oracle Application server, 9iAS including on Linux, VMware, HPUX and AIX servers. Applied patches and performed Technical Health Checks on Database instances as required
• Carried out Oracle Database maintenance; base lining, performance tuning, alert configuration using snap shots taking by Automated Workload Repository (AWR) Automatic Database Diagnostic Monitor (ADDM) and Oracle Enterprise Manager (OEM) to generate performance reports, monitoring database performance, securing & protecting information/database with unique secure configurations, data encryption and masking
• VMware infrastructure configuration and setup (resource pool, storage pools, virtual network switches, etc.).
• Installed Oracle Grid Infrastructure, ASM, Oracle binaries and configured Databases (10g, 11G and 12c).
• Installed Oracle EE 12c instance with seed database comprising of multiple pluggable DB in a multitenant CDB
• Configured Oracle Data Guard to provide a disaster recovery solution with 2 or more Data Guard standby target for each of the databases for customers.
• Utilized Oracle Enterprise Manager / Grid Control / Cloud control to monitor and manage databases as applicable
• Cloned, Database Refreshes, data migration and Restored Oracle Database from production to testing platforms
• Installed appropriate RDBMS patches and tech-stack patches such as upgrade, CPU, DST, one-off, roll-up, mini and family patches.
• Exposure to Exadata setup and configuration with Oracle automations
• Oracle E-Business Upgrade (DB Tier and Application Tier) 11.5.10.2 and 12.1.3
• Installation, configuration and maintenance of E-Business 12.1.3 and 12.2.2.5
• Support on-going Oracle E-Business Production and Development and housekeeping functions.
• Installed, configured and upgraded Oracle e-Business Suite 11.5.10(R11i) to R12.1.3.
• Upgraded EBS 12.1.3 to 12.2.3 on Linux server, and RDBMS Upgrade to 11.2.0.3 and 12c
• Installation, configuration and management/support of Oracle Business Intelligence Enterprise Edition (OBIEE - 10g, 11g) and Hyperion Essbase system for multiple clients
• Proficient in EBS Installation, Patching, Cloning, Database Refresh, Upgrade (EBS and Database), Disaster Recovery, High Availability and Backup & Recovery (RMAN) in EBS 11i, R12.1.x and R12.2.x
• Experience in Upgrading Oracle EBS from 11i to R1213 with DB size of more than 2 TB and R1213 to 12.2.5
• Migrating Oracle Databases from non-ASM to ASM and Vice-Versa
• Assist with Installation, Configuration, Patches, Upgrades and administration for SQL Server 2005, 2008, 2012 in Clustered (Failover) and standalone environments.
• Experience in Migration of SQL Server 2005, 2008R2/2008 to SQL Server 2012(side by side and in-place) which included production and non-production environments
• Assist in implementation of High Availability/Disaster Recovery concepts (AlwaysOn Database Availability and Instance Availability) for SQL Server 2005, 2008, 2012 versions
• Provide support for test and production Database environments to include problem identification, reporting, tracking, analysis and resolution.
• Managed and coordinate ETL processes and tasks. Monitor the SQL Database performance and space utilization.
• Established, maintain and monitor database back-ups, database security, user-role assignments, and individual logins per company security policies and procedures.
• Experience with automation and tools designed to support highly transactional databases for large scale and with highest levels of availability.
• Customized menus and responsibilities, changed profile options and managed other sysadmin functions in Oracle applications and Experience with Oracle EBS System Administration skills including concurrent requests, printer setup, and user administration
• Implemented an optimized Oracle RMAN backup strategy that completes full backup of multiple Terabytes size Database in less than an Hour compared to 10hrs runs
• Research, analyze, and recommend patches, tools, and/or database upgrades to resolve issues and add features and functionality. Including Writing of bash shell scripts and familiar with OS/administration commands
• Installed and configured RHEL, CentOS, Ubuntu, OEL, Solaris and Windows from scratch on Virtual severs and configured them for software installations, Including Day to day administration along with user permission management, FS creation / modify, server build, troubleshooting Etc
• Possess good knowledge of Ansible automation tool for deployments, using playbook.
• Troubleshooting / Performance Monitoring with glances, Zabbix, top and other OS monitoring tools to resolve different applications issues
• Perform day to day supports for customers, and all enterprise servers in a production and pre-production.
• Installation, configuration and management of GlassFish, Apache Tomcat, Jenkins and deployment of war files
• Installed and configured Splunk on various LinuxOS and used it to collect and index application data.
• Configured and supported various applications on windows 2008, Solaris 11, RRHEL, HPUX, CentOS, Ubuntu, OEL and Performed server updates, upgrade and package installations using RPM and YUM
• Configured multi-nodes Hadoop cluster environment and client applications/administration tools like (HIVE, SQOOP, FLUME, PIG, OOZIE, IMPALA etc.)

Confidential, Atlanta, GA

Snr. Database Support Consultant

• Participates in the project feasibility process and defines the database infrastructure to fulfil project requirements
• Performs system and database analysis and provides strategic planning, development and implementation, and maintenance of database management systems
• Configured, maintained Oracle Real Application Cluster (RAC), Data Guard with standby and Observer and managed them for high availabilities for multiple clients
• Undertook troubleshooting, research and resolution of complex database and application problems by closely monitoring and tuning of development and production database performance issues; identify problems and implement solutions; ensure the database is running at optimal speed and efficiency---tuning and optimization of Database Buffer cache, db cache, PGA, Library cache, Dictionary cache, SQL statements using scripts, Oracle Statspack, Oracle trace, TKPROF, Automatic Workload Repository (AWR), ADDM, OEM/Grid Control, spotlight, Toad and DBArtisan.
• Design/Implement/Support Oracle Goldengate Replication from end to end and manage key database releases for DEV, QA, UA, Production and DR as part of the overall SDLC.
• Maintain databases by patch applications and enhancements/upgrades of environments and Automate routine maintenance tasks using standard scripting practices
• Troubleshooting and Solve non-routine problems and determine the best solution through cost/benefit analysis also Improve efficiency and quality of delivery by automating routine tasks.
• Work with other teams within operations and peer groups like Development, QA, Apps admin, Web Admin as a lead and/or member.
• Work with IT Server Management, Storage Admin, System Admin and other groups and make sure that all events, incidents and problems are resolved as per the SLA.
• Contribute to best of breed product support tools including run books, monitoring, and knowledge bases to aid in the product support process.
• Suggest improvements to existing processes and tools used and also suggest implementation ideas.
• Installation, cloning and maintenance of following Oracle products in HA configuration: Oracle EBS suite, Oracle SOA suite (11g), Oracle DISCOVERER (11g), Oracle OAM/SSO (11g), Oracle RAC (11g), Oracle OBIEE (11g)
• Experience in implementing patching strategy to keep Prod and non-prod instances in sync with oracle patches.
• Provided technical support for Production and development/project instances.
• RAC 11g database administration with data-guard setup and implementation on multi-nodes
• Collaborate with business and IT delivery teams in the evaluation, selection and/or development of application software solutions
• Provided weekly status report on Application and databases performance.
• Maintained and developed backup/recovery processes for Oracle Applications using RMAN.
• Implementing shared database file systems in a SAN/NAS/RAC environment.
• Build physical standby and logical database with Dataguard configuration.
• Monitored OS file system, I/O, CPU, SWAP, memory and network utilizations on UNIX and Windows 2000 and ensures efficient use of disk storage; Reclaim spaces; optimize space allocation and avoid out-of-space conditions.
• Database upgrade from 10.2.0.4 to 11.2.0.2 on Red Hat, HPUX and AIX.
• Worked on all phases of a project: development, testing and production support.
• Supported Oracle databases and ensured their availability 24x7 with EBS and non-EBS environments.
• Responsible for Oracle database administration activities in support of development and production systems supporting web-deployed applications
• Participated in an on-call rotation schedule to provide off-hours and weekend production support
• Followed and maintained policies and procedures to ensure internal database systems availability.
• Installed, configured Golden Gate and Troubleshot Golden Gate replication issues (11.2.0.2).
• Apply database patch and Golden Gate patch and Prepare Root Cause Analysis RCA.
• Experience with Oracle Hyperion / Essbase Administration, Oracle Fusion Middleware, including WebLogic.
• Experience with Oracle Enterprise Manager for monitoring, administering and optimizing applications & DBs.
• Advises Management and other business processes regarding the feasibility of proposed approaches to project solutions in terms of systems capabilities and established technology architecture guidelines
• Patched oracle database and grid agents in both RAC and Stand-alone when needed
• Database security Management, session management, set up database system, session and statement auditing strategies, creating and administering database users, roles, privileges, profiles, backup, recovery, and security to ensure compliance with corporate security and control standards, and SOX Act and PCI compliance.
• Utilized various Oracle and open-source monitoring tool and writing custom database-monitoring scripts to Monitor OS file system, I/O, CPU, SWAP, memory and network utilizations on UNIX and Windows 2000 and ensures efficient use of disk storage, reclaim dead space, optimize space allocation and avoid out-of-space
• Ensures uniformity across IT systems infrastructure to enable effective application integration capabilities
• Created user, views and tablespaces, allocation of appropriate tablespace quotas with necessary privileges and roles for Oracle databases and Managed backup & Recovery for Oracle on Linux using RMAN
• Database Migrations from 9 to 10 and 11G, Patching and Upgrade of Oracle
• Experience in Linux/ Unix shell scripting, shell command, crontab and vi editor with excellent database performance tuning and capacity planning skills

Confidential

Software Engineer / DBA

• Installed, configured, tuned and troubleshoot Oracle Database 9i/10g and SQL Server 2005
• Implement database backup & recovery, data models, database designs, data access and table maintenance codes.
• Responsible for deployment and support of high-availability, high-volume and enterprise-class Oracle database
• Build, configure, and maintain OBIEE platform in HA/Non-HA mode on UNIX.
• Start-up and shutdown the Oracle Business Intelligence Suite application servers and web servers.
• Troubleshoot issues raised by users and provide timely resolutions.
• Upgraded database instances to 11.2.0.2 on 2 nodes RAC Clusters with 3 AppsTiers.
• Worked with application developers to resolve poorly performing queries.
• Responsible for database performance and tuning (AWR reports, explain plans, 10G/11G Advisors).
• Build standby /data-guide databases for supporting different business needs.
• Upgraded CRS and ASM 10.2.0.1 to 11.2.0.2 on 2 nodes RAC clusters on Linux.
• Used RMAN for Backup and Recovery.
• Worked with UNIX team on the development of policy and procedures as they relate to database maintenance, security and archiving.
• Monitored database performance in RAC environment using Grid control and custom scripts.
• Performed Oracle installations and upgrades as well as installing patches.
• Ensure the success of all system back-ups with the ability to perform restores on demand Participated in bi-weekly team meeting and on-call support role 24x7.
• Was first line of response to troubleshooting database and reporting issues, server clustering and load balancing technologies for high-availability and Provide assistance in SQL statement tuning to improve performance
• Generated various reports from database as needed and performed database tuning for multiple clients
• Carried out Oracle Database maintenance; base lining, performance tuning, alert configuration, using snap shots taking by Automated Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) to generate performance reports, monitoring database performance, securing & protecting information/database with unique secure configurations, data encryption and masking procedures as well as with sophisticated auditing skills
• Lead team to successfully upgrade multiple IT infrastructures, databases and carried out short term performance tuning, maintenance and training for continuous operation for multiple clients including Sykes Energiprojekts ltd.
• Implement replication/backup/recovery of databases and database movement between environments using Oracle Recovery Manager (RMAN), Oracle Dataguard & Goldengate.
• Ensuring proper configuration and security on all database servers