SUMMARY

• Very extensive 12 years of experience working in 7x24 and critical environment as DBA, Senior Software Engineer and Technical Lead doing design, implementation, development, ongoing support for very large Oracle databases using Oracle RAC, Data Guard, ASM, Replication, Golden Gate.
• Extensive experience working wif logical/physical designing of the databases, creating, administrating and tuning the databases using Oracle 8i/10g/11g in Government (Railways), Banking, Financial, Telecommunication and Information Technology industries on different Sun Solaris/Linux/AIX & HP - UX.
• Rich experience in Oracle high availability RAC cluster setup, monitoring and maintenance task on Production, Dev & UAT Environment on Linux/Solaris OS.
• Twelve years of experience wif Database Development (SQL, PL/SQL, TSQL) and Database Administration (Oracle 8i/10g/11g, Postgres, Sybase SQL Any Where, Sybase Adaptive Server) on different operating platforms like Win 2K/2K3, HP-UX, Sun Solaris, AIX, Linux (Red Hat, Oracle Linux, CentOS, Ubuntu) in bare metal as well as cloud environments.
• Extensive working experience in 7x24 critical Oracle RAC/OPS, Data Guard, Stream, Replication database environment for design, implementation, tuning, maintenance and on-going support
• Excellent experience working and administrating small, medium, VLDB databases for OLTP, OLAP, Data Marts, Data Warehouse environments and work for database design and tuning for OLTP, OLAP and Data warehouse using different Oracle functionality and features like partitioning, transportable tablespaces, bitmap/b-tree indexes, index organized table, shared servers etc. Also, work as Production & Development DBA and support developers for tuning, security, data refresh, data loading, data migration
• Design and Implement different backup and recovery strategies for Oracle databases using Oracle RMAN, Oracle Export/Import, Veritas Netbackup per different business requirements
• Working knowledge working wif open source SQL based relational databases (MySQL and Postgress).
• Tune Oracle databases using different tools and utilities like Statspack, AWR, ADDM, ASH, Oracle EM (11g/12c) Oracle Tuning Pack, Oracle Performance Pack, Oracle Enterprise Manager, Explain Plan, TKPROF, Performance Views (V$ views), AWR reports, ADDM, BMC Patrol and self-written queries
• Work wif storage estimation, storage maintenance, security management, auditing, user/privileges management, defragmentation and resource management for Oracle
• Good working experience wif different database development and management tools like SQL * Plus, SQL Loader, Server Manager, TOAD, Oracle Enterprise Manager (11g/12c), BMC Patrol.
• Help and train application developers for SQL tuning, designing, implementing roles based security, data consistency, data integrity, data loading etc.
• Experience in writing Shell scripts Through Unix and Shell to automate business process and scheduled jobs.
• Good working experience for managing Projects and group of DBA as a Technical lead
• Worked on different projects as Technical Lead and PM doing architectural design managing technical people locally and offshore.
• Good negotiation, documentation, resource/people management skills
• Flexible, Committed and highly “Customer Focused” while dealing wif clients, upper management, team players and peers

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta

Oracle/Sybase DBA

Responsibilities:

• Leading the offshore/onsite TechM DBA Team to provide continuous round the clock support, monitoring SLA’s, apply & use best practices, create and maintain DBA procedural documents, coordinate wif other stake holders, maintain CR schedules etc.
• Work as a DBA on Oracle databases of AT&T’s one of most critical applications (U-Verse, LS, Canopi) where a small outage counted for millions of dollars to business.
• Support AT &T’s high availability databases (7 x 24) using Oracle 9i/10g/11g/12c, RAC, ASM, Data Guard on Linux and Solaris platform for U-Verse, IDIS, DSL, Light speed, CRAMER, CIM,, BBNMS-SE as a Lead DBA
• Install, Upgrade, Troubleshoot & Maintain Golden Gate in Production Environments.
• Implemented Oracle Enterprise Manager Grid Control 11g and Enterprise Manager Cloud Control 12c for monitoring, alerting, troubleshooting, tuning and reporting.
• Implemented Oracle privilege level, object level and statement level auditing
• Upgrade Oracle databases from Oracle 9i to 10g, 10g to 11gR1, 11gR1 to 11gR2, 11gR2 to 12c using different approaches like export/import, manual process wif upgrade scripts and database upgrade assistant (DBUA).
• Work on Application, Database and SQL tuning problems using Oracle EM, SQL Tuning Advisor, SQL Profile, ADDM, AWR, ASH, Oracle DBA Hist and Oracle Workload Repository views, Explain Plans and other UNIX tools & utilities like SAR, TOP, VMSTAT, RAC Check, OS Watcher etc.
• Review, recommend and Install Oracle security and CPU & PSU patches for different environments
• Review & Test Oracle new features and recommend suitable new features for implementation like Oracle 11g Advanced Compression, Partitioning, Active Data Guard, etc.
• Work a System DBA as well as an Application DBA. Work wif developers to promote new releases in dev, test, QA, pre-production and production environment
• Review Oracle performance reports (AWR, ADDM, ASH) and logs (Alert Log, Traces) on regular basis to identify any performance and general problems. Also, investigate those problems using Oracle reports, logs, performance views, Metalink to provide suggestion for tuning and resolution
• Maintaince of DB’s in VCS HA environments.
• Maintaining Oracle Application Express used for tracking of various DBA initiatives.
• Work as a team member wif SAs, SCMs, Architects, Developers, PMs and Application Managers for troubleshooting and resolving any problem. Also, participate in Recovery Team as a consultant for the resolution of any critical production problem
• Do Knowledge transfer to junior and offshore DBAs for daily operations and new Oracle features.
• Prepare documentation, run books, test cases for database design, implementation, ongoing support and work as a mentor for junior/intermediate onshore/offshore DBAs.
• Installation and configuration of ASE servers on SunOS and Linux on Lehman standards.
• Monitoring the system based at Sybase ASE level as well at OS level using utilities like iWatch etc.
• Looking into performance and interacting wif users to get resolved.
• Creating Devices and Databases according to Lehman standards.
• Creating autosys jobs for automating jobs like backup, update statistics, Reindex etc using in-house Lehman utilities like DMT etc.
• Taking up ad-hoc requests from users pertaining to variety of database tasks, monitoring system for performance bottlenecks etc.
• Writing SQL and OS level scripts for automating the periodic ASE administration tasks.
• Working on technologies like LDAP, Kerberos, Single Sign On (SSO).
• Coordinating wif SA team on exercises like Cluster migration, OS migration, EMC upgrade etc.
• Implementing various DR strategies like EMC SRDF, Warm standby Replication, Table level Replication.
• Capacity planning for database servers based on the metrics available for the server.
• Experience wif handling monitoring systems like HPOV monitoring for the database instances.
• Documenting steps and procedures for activities being performed pertaining to the database world
• Installation and configuration of homogeneous replication setups.
• Monitoring the system at Sybase RS level as well as OS level.
• Monitoring the Replication Connections and stable queues
• Looking into performance issues of Replication Server.
• Checking the integrity and consistency of RSSD database and stable queue partitions.

Railway Information Systems

Confidential

Responsibilities:

• Designing, developing, testing, troubleshooting and debugging of the application.
• Index Tuning for enhancing the performance of the database.
• Analyzing and monitoring system performances using DBCC Trace on commands, query plan outputs, system procedures like sp sysmon and system utilities like Optdiag etc.
• Responsible for 24/7 production support of 5 Sybase servers(15 databases)
• Running health check report on the database.
• Monitoring Sybase servers and troubleshooting monitoring scripts
• Responsible for major releases and preparing an impact analysis of the changes
• User/group and login creations and implementing security/password policies
• Responsible for attending to overnight batch job failures and trouble shoot DBA problems.
• Setting up cron jobs for DBA tasks
• Fixing log full/tempdb issues
• Installation, configuration and up gradation of Sybase servers
• Capacity planning and space management
• Setting up and monitoring alert logs for failures