SUMMARY:

• Total 10+ years of experience as Oracle DBA.
• Extensive experience in installation, configuration, upgrade, and maintenance of Oracle 12c/11g/10g RAC, configuring Oracle database on Unix, Linux/HP servers, Windows platforms with ASM. Hands on experience in writing Unix Scripts using Korn Shell
• Solid hands on experience in space management, capacity planning, database backup & recovery using RMAN/ZDLRA, performance tuning, application tuning, and query optimization using Oracle supported tools such as OEM and Explain Plan. Administered database of over 10 - 12 TB data
• Experience in tuning and development of large and complex PL/SQL procedures/packages
• Experince in creating and maintaining DataGuard and Goldengate.
• 5 years of experience as Datawarehouse DBA.
• Proficient in logical and physical database layouts and managing large, heavy volume, commercial grade, distributed and remote databases
• Hands-on experience in data modeling, database security, and auditing working with tools such as SQL*Plus, TOAD, SQL Developer and Export/Import utilities along with Oracle Enterprise Manager (OEM), expertise in Datawarehouse DBA and Exadata machines
• Extensive exposure in RDBMS architecture, design and development in Oracle 12c/11g/10g/9i/8i
• Worked on cross-functional teams successfully interacting and communicating with intra-inter organizational technical groups and client services. Working closely with program level stake holders providing team level updates
• Continously staying up to date with current and emerging technologies to maintain skill levels necessary to providing quality services to customers, and having strong analytical, mathematical, and strategic thinking capability with good communication and interpersonal skills

TECHNICAL SKILLS:

• Oracle DBA
• Data Guard
• RAC
• ASM
• RMAN
• OEM 11g/13c
• GoldenGate
• Exadata
• PL/SQL
• Linux/Unix/HP Unix
• Datawarehouse
• Shell Script
• SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Plano, Texas

Oracle DBA

Responsibilities:

• Part of the core production DBA team managing heavy volume - business critical environment
• Administered and managed Oracle 12c/11g/10g Database of 2/3 nodes with ASM on Linux, HP Unix
• Actively worked on Oracle Exadata Machine for running Oracle Database software and optimizing workloads. Monitored and managed databases using the Oracle Enterprise Manager (OEM) 13c
• Monitoring Golden Gate Database .
• Successfully migrated databases to the Amazon AWS Cloud using the Relational Database Service
• Worked on real time data integration and replication in heterogeneous environments at transaction level leveraging the best in class Oracle Goldengate
• Hands on working in Enterprise Datawarehouse on Production, Development and Test servers
• Successfully migrated Dataearwhouse and Business Object database of 15 tb from Oracle 10g/HP Unix to Oracle 11G/Linux on Fusion IO and subsequently on 12c/11g/Nimble
• Created, maintained synchronous standby databases for supplimentary reporting purposes
• Day to Day active maintenance for space management, users, SQL/Objects performance tuning
• Performed daily backups and recovery of databases using Oracle ZDLRA and Oracle RMAN
• Maintained heavy volume commercial grade datawarhouse databases of 10-12 tb
• Developed, maintained and updated the data flows from various format input files to datawarehouse servers to Business Object servers
• Performed reporting and SQL tuning on datawarehouses and Business Object Databases
• Worked as Production DBA. Part of on call support for numerous production databases
• Collaborated with various teams on multiple projects, worked closely with product owner and architects to consistently design, develop, estimate, track and deliver the sprint cycle deliverable.

Environment: AWS, Oracle Exadata Machine, Oracle Enterprise Manager (OEM) 13c, Oracle Goldengate, Oracle 12c/11g/10g, TOAD, Grid 13c/11g, Oracle ZDLRA, Oracle RMAN and Shell Scripts

Confidential, Arlington, Texas

Database Administrator

Responsibilities:

• Administered, maintained and tuned Oracle 10g database on Sun Solaries platform, working on back end Oracle databases for for high volume Veria eCommerce website
• Installed, configured and maintained millennium CO database at corporate office and at various retail stores and synchronized with CO database
• Participated in core strategy formulation and designing of various accounts and sales database, and successfully installing and configuring the data bases to maximise performance
• Generated periodic and on demand granular sales reports using various queries on the databases thus providing business, management, sales and stake holders with best in class analysis data
• Used Oracle Enterprise Manager (OEM) for managing and monitoring databases, Installed and configured the server on Window for use as a parallel test server
• Administered MS SQL Server 2005, installed and configured of database server on Window 2003 OS
• Carried out in day-to-day maintenance and development of databases comprising of configuring, backup, space management, and performance tuning
• Collaborated with trained teams on multiple projects on the intricate workings of new and existing database applications and tuning methodologies for uniformity and best practices

Environment: Oracle 10g, MS SQL Server 2005, Oracle Enterprise Manager (OEM), Window 2003

Confidential, Dallas, Texas

Database Analyst

Responsibilities:

• Converted an existing DOS based software for Material Requirement Planning (MRP) to SQL Server platform
• Installed and upgraded database and user configuration for client setup
• Participated in application design, documentation, coding, testing, and release of material requirement planning application
• Generated various perodic and on demand reports related to inventory, sales, and purchasing that directly aided top management and business stake holders in key analysis and descicion making
• Participated in day-to-day monitoring, performance tuning, back up and replication of databases

Environment: MS SQL Server 2000, Crystal Reports

Confidential

Manager - Systems, Full Time Employee

Responsibilities:

• Lead system study, business analysis, requirement gathering and user interaction for Financial Accounting, Material management and Human Resource management System projects
• Lead and developed applications along with the development team using Forms, Report 6i & PL/SQL
• Implement applications on Oracle 9iAS and trained users, testers and technical staff
• Participated in the strategy, design, and implementation for backup, restore, and high availability of server and data migration across different platforms
• Identified and resolved production problems related to performance and operational issues
• Guided to DBAs in creating DB schemas, users, rolls and space management on Oracle 9i server
• Participated in production database administration, maintainence and performance tuning
• Lead team members in crucial situations to successfully complete the project before target date
• Worked successfully with cross functional teams to achieve targets. Provided system level demos and progress reports to business and management stake holders
• Worked with Project Management and Client facing teams to deliver prompt solutions for client issues and configuration request

Environment: Oracle 9i, Oracle 9iAS, HP UNIX, Forms, Report 6i and PL/SQL

Confidential

Systems Analyst

Responsibilities:

• Developed applications such as Inventory System, Product Reporting and Dispatch System, Hospital Management System using Forms and Report 5 & PL/SQL, Involved in System study and Database Design
• Implemented Oracle 7.x, converted the existing application in Oracle using Forms, Reports 5
• Delivered Oracle data load using SQL Loader from Fox pro, tested applications with real data in parallel runs
• Responsible for Lotus Domino R4.5 server administration. Set up of organizational Unit Server, Creation of connection documents for mail routing and replication of various intranet applications; set up of replication schedules, registration of new user group, setting up the notes client, and managing access control for various application databases.

Environment: Oracle 7.x, HP UNIX, Lotus Domino R4.5, Forms and Report 5 and Fox Pro