Results-oriented Senior Oracle DBA professional with demonstrated success providing technical skill and expertise in database management. Displayed expertise through three plus years as an Oracle Certified Database Administrator.

• Able to plan, install, manage and maintain mission-critical Oracle Databases.
• Highly skilled at understanding relational database design and database administration, strong expertise with UNIX flavors (Solaris, Linux and AIX), as well as Windows Operating Systems.
• Skilled at analyzing, presenting, storing, organizing, utilizing data and ensuring safety/security.
• Led initiatives to set up and troubleshoot new databases based on organizational needs and resources.
• Experience at recovering lost information, upholding security of lines of communication.
• Expert in database backup such as user-managed backup, RMAN-managed, backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup, implementing backup and recovery strategies, applying patches, performance monitoring, tuning, shell scripting and troubleshooting.
• Solid experience in advanced replication, and standby database using Data Guard 9i/10g and also expert level experience in OracleASM 11g , export/import utilities, Data Pump and SQL* Loader.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, TOAD, monitor users, tablespaces, memory structures, rollback segments, logs, and alerts.
• Adherence to processes including Change/Incident Management, Ticketing system, Configuration management, etc.
• Expert in administration and maintenance of Oracle RAC 10g, 11g databases
• Demonstrated as a team player as well as an independent worker with communication, motivational, and influencing skills.

Education & Certifications
Master of Business Administration (Operations)
Bachelor of Technology (Information Technology)
Oracle 11g certified professional.

Technical Competencies

Oracle10g/9i/8i, MySQL

Languages:

Shell Script, SQL,PL/SQL, awk scripting

Operating Systems:

AIX 5.X, UNIX (Sun Solaris) / Red Hat Linux, Windows 2000/ XP /NT 4.0

Tools:

Oracle Enterprise Manager, Embarcadero DBArtisan, SQL*Plus, RMAN,SQL *Loader, Toad, LogMiner, Autosys, L/SQL Developer, Statspack, TKPROF, PUTTY, VI editor, Unix Shells - Bash/ksh/csh, WinSCP

Protocol:

TELNET, SSH

Professional Experience

Confidential, Boston MA 8/2006 - 10/2007
Senior Database Administrator

Project: GETT - Global Equity Trading Technology Databases
Scope: Databases handle equity data, clone data and all broker data required for Traders to execute orders issued by Portfolio Managers.
Environment: Oracle 10.2.0.2, AIX 5, Embarcadero DBArtisan 8.1, Shell scripting, Autosys; Database size 300 GB

Responsibilities:

• Designed and implemented database backup strategy and performed full incremental and Cumulative backup using RMAN
• Setup, configured and maintained Oracle DataGuard to control primary and standby databases and ensured disaster recovery using various data protection modes
• Performed table partitioning and oversaw daily loads using SQL*Loader, full export and DATAPUMP
• Performed Automatic segment space management (ASSM).
• Checked and monitored the database health daily
• Applied the Oracle security patches using the OPATCH utility.
• Performed optimization and fine-tuning of the database by planning storage requirements, building indexes and altering storage clauses for tables and indexes
• Designed and developed UNIX shell scripts using Awk, Sed, etc to automate wide range of tasks including administration, backup, monitoring, troubleshooting database issues, execute background and batch process round the clock
• Performed database tuning by using various tools TKPROF, DBArtisan and STATSPACK
• Provided 24/7 monitoring of database operations to ensure top operating efficiency on an on-call rotation basis.
• Created oracle service names and listener configuration as and when required
• Documented the database setup, backup details, and other procedures for future reference and solutions.
• Analyzed workload of group and recommend improvements - continually enhanced the group's skills around client satisfaction

Confidential, Boston MA 8/2006 - 10/2007
Senior Database Administrator

Project: ODS - Operational Data Store
Scope: Ensure optimal operations for databases used for OLTP purposes for analyzing market trending
Environment: Oracle Server 10G/9i, OEM (Oracle Enterprise Manager), AIX 5, Embarcadero DBArtisan 8.1, Shell Scripting, SQL*Plus, PL/SQL; Database size 850 GB

Responsibilities:

• Provided database administration on production, testing and development database servers
• Estimated storage requirement, created tablespaces and other database primary objects
• Prepared backup strategy and disaster recovery management of databases using RMAN
• Extensively worked in setting up Oracle physical, logical standby database and data guard
• Initiated and performed change management requests
• Fostered efforts for successful migration of the database from 9i to 10g
• Performed tuning of databases based on analysis of utilities such as TKPROF, EXPLAIN PLAN, etc.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases.
• Used Oracle Virtual Private Database to enforce security to a fine level of granularity, directly on database tables, views, or synonyms
• Implemented Oracle 10gASM feature with external redundancy.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP
• Clone/Refresh of production databases to testing and training environments
• Implemented Oracle Replication through materialized view; created and maintained resource plans
• Monitored system resources of database servers to assure production systems meet availability requirements and hardware enhancements are scheduled in a timely fashion
• Automated and maintained scheduled jobs with the help of db scheduler and autosys tool

Confidential, 8/2006 - 10/2007
Senior Database Administrator

Project: ETIW - Equity Trading Investment Warehouse
Scope: Databases are used for OLAP purposes and they maintain the current and historical equity data, as well as used for batch operations and for report generation purposes.
Environment: Oracle (10g/9i) on AIX 5, Oracle Enterprise Manager (OEM), Toad, Embarcadero DBArtisan 8.1, Shell Scripting; Database Size 4 TB

Responsibilities:

• Provided replication troubleshooting and solutions for various replication issues; provided Oracle Patch installation
• Performed large terabyte size database backup including physical backup through hot backup/cold backup of Oracle Database, RMAN, also logical backup using multiple streams export / import, Incomplete recovery and disaster recovery using Standby database or Data Guard
• Designed and developed scripts designed to monitor instances locks, long running queries, listener, free space, extents growth, etc.
• Met the SLA on each database by maintaining high availability / uptime
• Involved in the capacity planning for databases based the future business growth requirements
• Coordinated with developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, security, backup & recovery, and SQLs coding guide lines
• Tuned SQLs using explain plan, SQL Trace, Statspack, TKProf, etc and emphasized achieving maximum stability and security, while maintaining performance and customer satisfaction
• Configured listener and services manually and using Net Conf. Assistant
• Collected incident/change ticket details and sending it to the client providing On-Call support
• Involved in regular DBA activities like creating users, granting privileges, creating roles, entire User Management activities, Tablespace management, Redolog Management

Confidential, 6/2004 - 7/2006
Database Administrator

Project: IWAY, VOIP, NAVIS, GE, SafeScrypt
Scope: These database servers maintain all the revenue and connection details of all the customers who access Internet through Iway cyber cafes, home and voice over IP phone connections, etc. Hosted Databases for external clients. Installing and upgrading new versions of Oracle on test servers.
Environment: Oracle 8i/9i/10g, Solaris 8/9, Linux Advance Server 3, Shell scripting

Responsibilities:

• Handled the administration and management of all databases including managing standby databases
• Involved in Schema (user) management, Tablespace Management, Rollback/undo Segment management, Redolog Management, User Creation, Creating profiles, Granting Privileges
• Provided daily support by monitoring and assisting with space management issues, capacity planning, back up status and any user management issues
• Initiated backup activities like maintain hot backup and Export and Import dumps
• Handled ORA-1555 errors and monitoring rollback segments
• Monitored temporary tablespace, monitored disk usage at the OS level and tablespace level
• Maintained physical standby database and performing switchover/failover when required
• Re-organized tables and indexes, applied patches and patchsets
• Created cron entries at the OS level to run scheduled scripts
• Monitored the archived log disk location and moving them periodically to tapes
• Created Oracle service names and listener configuration, provided technical inputs to the management
• Monitored the various database activities by developing shell scripts and using various tools
• SQL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning Advisor