SUMMARY:

• 12 years, 7 years in Database Administration, 5 years in System Analysis and design
• Implementation of disaster recovery plans, data guard, oracle streams on Real Application Cluster environment for core databases and Oracle EBS.
• Development of software applications using SDLC phases (analysis, design, development, implementation, support, testing, ) using Oracle tools and technologies.
• Strong in software / patch installations, upgrades, database configurations, performance monitoring and tuning, replication design and implementation, and various problem solving and troubleshooting relational databases issues. Specialized in installation, configuration and maintenance of 10g Grid Control, to monitor and manage oracle eco system.
• Expert in designing and implementing data integration solutions using Oracle Advanced Queuing, Replication and customized PL/SQL code.
• Involved in complete life cycle of projects including projects of large databases, both Operational (OLTP) and Data Warehouse (DSS) systems, performed systems analysis, design and implementation and maintenance.
• Experienced in Standardizing, documenting, and automating systems. Well versed in financial management i.e., Budgeting, Total Cost of Ownership (TCO) and cost optimization. Worked with internal / external auditors’ vis - à-vis SOX compliance and other security issues.

TECHNICAL SKILLS (SOFTWARE TOOLS & TECHNOLOGIES):

Project Management: Microsoft Office Project 2010

Operating Systems: Windows Server 2008, UNIX, Oracle / Red Hat Linux

RDBMS: Oracle EBS R12/11g/10g, Oracle Database 12C/11g/10g, Oracle Data Guard 10g/11g, Oracle RAC 10g/11g, MS SQL Server, TOAD, PL/SQL Developer

Backups: RMAN, Data Pumps, IBM Tivoli Storage Manager (TSM), RMAN, Tivoli Data Protection for Oracle. Custom shell scripts

ETL Tools/Utilities: Oracle 10g Grid Control, OEM, DBA Studio, Server Manager, OMS Intelligent Agent, TKProf, ExplainPlan, STATSPACK, Oracle Datapump, SQL* Loader, SQL Navigator, DBMS JOB

Network: TCP/IP, SQL*net, JDBC, OCI, ODBC, OLE, DBD DBI, Oracle OID LDAP 3.x, Names

Web Technology Tools: HTML, Java Script, JSP, Apache Tomcat

EMPLOYMENT HISTORY:

Confidential

Database Administrator

Software/Applications: Windows 2008, Oracle Database 11g Release 2 on Oracle Linux, PL/SQL DeveloperOracle Application Server, Oracle Developer 10g, EBS R12, Data Guard, RAC, ASM

Responsibilities:

• Responsible for supporting SQL Server & Oracle databases and troubleshooting problems for multiple projects.
• Providing 24/7 Production Database on Call Support.
• Proactive monitoring of SQL Server/Oracle/Development/QA instances.
• Coordination with storage, developers, vendors & end-user teams for ensuring maximum uptime & performance.
• Tuned several databases to guarantee fast & smooth routine operations.
• Done Capacity planning & written scripts to generate utilization trend report for monitoring Disk space or Disk I/O utilization.
• Delivered the following reports, Software requirement specification (SRS), Software design description (SDD), Implementation steps, acceptance test plans (ATPs). Policies, Processes (ITIL methodology) and Procedures and Database advisory services subscription and resource planning.
• Installed & configured various 2/3/4-node RAC 11gR2 using ASM on Oracle Linux 6.5.
• Installed & configured Oracle 10g/11g Dataguard on RHEL 5.4/6/5.
• Migrated Oracle Database from 10g (Windows bit) to 11g (Windows bit).
• Upgraded Oracle Databases from 10.2.0.1 to 10.2.0.4 on RHEL 6.4.
• Installed several Oracle instances in RHEL 6.4 & Oracle Linux.
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Managing & proactive monitoring of Oracle Production/Development/QA instances.
• Wrote several SQL and OS scripts for backups on local/remote servers and on Tape drives.
• Design & Implemented backup restore solutions.

Confidential

System Analyst

Software/Applications: Oracle 8i database running on IBM RS-6000 F Series Server and Compaq Server.

Responsibilities:

• Involved in Business process analysis, Installed and managed Inventory Management, Maintenance Management, General Ledger, Accounts Payable and Accounts Receivable, Fixed Assets, Human resource management, Shares Management modules.
• Installed and configured Oracle Databases for various applications.
• Migrated Oracle 7 database to Oracle8 and Oracle8i. and Oracle Net 2 to Net8.
• Served on an end-to-end implementation, upgrade or improvement project from assessment to production support as the primary DBA for key Oracle databases and services of the company’s enterprise application platform
• Provided specialized skills required for systems sizing and capacity prediction and consequently server hardware selection
• Setup, maintained and administered the replication environment for databases
• Setup and maintained reporting infrastructure
• Setup and maintained Data Guard
• Installation, configuration and maintenance of a large Oracle database environment consisting of database servers, client/server application, storage and backup devices in a distributed environment
• Designed and deployed the network infrastructure including LAN and WAN
• Database performance tuning and monitoring; data migration, user and system security, database and OS cloning, capacity and space management, problem resolution, hardware/infrastructure expertise, system documentation, and system management and support on a day to day basis
• Accountable for proper backup and disaster recovery procedures
• Responsible for applying patches to O/S, databases, custom application
• Trained the business users on the functional aspects.
• Trained the technical users on maintenance and administration of database, network and OS etc.

Confidential

Database Administrator

Software/Applications: Oracle 7 database running on Digital Server on MS Windows NT 4.0. Application written in VB connecting ODBC.

Responsibilities:

• Designed, installed and managed Sub ledgers of Accounts Payable and Accounts Receivables and Fixed Assets.
• Installed and configured Oracle Databases for various applications.
• Designed and implemented logical backups of databases using exports.
• Configured and Managed SQL*NET v2 on servers and clients.
• Implemented database security using database roles and views.

Confidential

System Analyst

Software/Applications: Oracle 7 database running on Digital Server on MS Windows NT 4.0. Application written in VB connecting ODBC

Responsibilities:

• Analyzing / Designing, reviewing and rewriting programs to increase operating efficiency and to meet the user requirements
• Preparing presentations and other procedural documentations
• Maintenance of program and backing up master data files and ensuring system’s security
• Setting up and configuration computer peripherals with the system
• Supervision / of personnel working on computer and provision of support for solving problems (hardware and software)
• Administration of WINDOWS-NT based network system and trouble shooting

Confidential

Computer Supervisor

Software/Applications: Oracle 7 database running on Digital Server on MS Windows NT 4.0. Application written in VB connecting ODBC

Responsibilities:

• Software application lifecycle development
• Responsible for analysis and development of new software projects for different departments of the organization and maintenance and upgrading of existing ones.
• Network maintenance and troubleshooting.
• To manage overall administration of the computer Section regarding procurements, dealing with commercial organizations, budget, record, correspondence, administrative problems, welfare of computer operators in area of responsibility.
• Developed Personnel Information System to maintain information about all employees working in area of responsibility.
• Developed Payroll System to calculate pay for employees working in area of responsibility.