SUMMARY

●Oracle Certified Database Administrator with 8.5 years of experience on Unix, Linux, AIX and Windows platforms for Oracle (9i,10g,11g, 12c) & SQL Server databases (2000-2014), having hands on experience in planning, designing, installation, creation, configuration, monitoring & administration of database systems, in Production, Test & Development environments.

●Experience in installation, configuration, development, maintenance, administration, upgrades & patching, performance tuning, backup, restore, recovery & backup validation procedures, cloning, capacity planning, database security, Real Application Testing (RAT), Real Application Clusters, Data Guard, ASM, Golden Gate, OEM 11g, Cloud Control 12c, performance tuning, backup, capacity planning for Oracle database environments.

●Extensive experience in developing database objects using SQL, T-SQL & PL/SQL

●Involved in all phases/steps of Project, including requirement gathering, planning, design, implementation, testing and deliverables.

●Experience working in RMAN, Data Guard, Golden Gate, Standalone, RAC, GRID, and ASM environments.

●Experience using datapump utilities, SQL Loader, External tables, etc.

●Database performance monitoring & tuning experience using SQL Developer, Enterprise Manager Grid Control 11g, Cloud control 12C, ASH, AWR, ADDM reports, TOAD, SQL Plus, SSMS, SS Agent, SS Profiler.

●Monitoring, administration & performance tuning of SQL server environment, support SSRS development, SQL Server Agent (automation & scheduling), SQL Server profiler & tuning advisor, Database Mirroring (HA/DR solution).

●Experience working in OLTP, OLAP, Production, Test/UAT and Development environments.

●Experience using Sharepoint and MS Dynamics CRM for documentation management & uploading, information sharing, etc.

●Knowledge of MySql, MongoDB, Exadata, SAN, Amazon Web Services (AWS), VMWare technologies.

●Experience in creating the reports/dashboard in OBIEE (Oracle Business Intelligence), crystal reports, and Discoverer.

●Significant knowledge in business/user processes and procedures, guidelines and documentation and Project management, experience in managing multiple projects simultaneously.

●Strong organizational, administrative and problem solving skills, statistical analysis skills, proficient with analytic and quality assurance, Experience leading small teams in developing and documenting business requirements.

●Good team player with excellent communications and interpersonal skills also can work independently to reach the deliverables.

EDUCATION

SRTM University, India

Bachelor of Engineering, Computer Science

CERTIFICATIONS

●Oracle Certified Associate

●Microsoft Certified Professional in Developing and implementing web applications with Microsoft Visual C#.Net & Microsoft Visual Studio .Net, ASP.Net

●Certified SQL Server Administration

●Crystal Reports Certified Professional (CRCP Ver. XI)

TECHNICAL SKILLS

Operating System:

UNIX, RHEL 4, 5, IBM-AIX 5.3, 6.1, 7.0, Windows 2003 server, Windows, NT/XP

Programming Language/Technologies:

SQL, T-SQL, PL/SQL, Shell script, JavaScript, C#, ASP.NET

Databases/RDBMS:

Oracle 9i, 10g, 11g, 12c, SQL Server 2000-14, MySQL, MongoDB, MS-Access, ODBC

Software Packages:

Macromedia Fireworks, Dreamweaver MX 2004, FLASH MX 2004, MS Excel, MS Project, Visio, Word, FrontPage, PowerPoint,

SharePoint, MS Dynamics CRM

Source Control: Visual SourceSafe, WinCvs, PVCS

EXPERIENCE

NEW YORK CITY HEALTH + HOSPITALS CORPORATION, NEW YORK

Feb 2011 – Till date

Database Administrator (Oracle/SQL Server)

Responsibilities:

Involved in database upgrades & patching, support Operating System upgrade.

Involved in workload capture & replay techniques (Real Application Testing: RAT).

Manage Database security concerning database users.

Capacity planning for production, development & test environments.

Application development & maintenance support for database objects.

Installation, configuration, upgrade, monitoring & administration of 12c database environment (multitenant, pluggable).

Monitoring & administration of Oracle Applications environment (RAC & Data Guard).

Involved in backup, backup validation, restore, & recovery strategies (RMAN, User managed, etc).

Database backups/restores using Veritas Netbackup media layer.

Involved in database reorg procedures (Compression, shrink, partitioning).

Tune database systems for optimum configuration & performance.

Involved in SQL Server database backup, restore strategies and upgrades.

Installation, configuration, monitoring, administration & performance tuning of SQL server environment.

Extensively used SSMS, DBCC, SQL Server Agent (scheduling), SQL Server profiler & tuning advisor.

Database mirroring for HA & DR solutions.

Create on demand database objects for SSRS, SSIS & SSAS development.

Mig VERITAS e, monitor & administer oracle instances to ASM storage in TEST environment.

Migrate databases to Exadata, NONASM to ASM, cross platform.

Replicated (using Data Guard) production to non production environments, for new development projects.

Installation, configuration, monitoring, maintenance and administration of Golden Gate environment (Production to non prod), for homogeneous and heterogeneous products.

Execute and monitor the monthly ETL process for the OLAP environment.

Provide support for Oracle Business Intelligence Admin, Discoverer Plus and Discoverer desktop users.

Application server monitoring, maintenance & administration. SSL configuration.

Follow data governance, HIPAA rules for clinical data management, accordingly.

Providing support for configuration, change and release management activities (BMC Remedy tool).

Provide 24X7 on call support.

Document, maintain and provide installation & procedural manuals for support staff.

Environment: Oracle 10g, 11g, 12c, AIX5.3, 6.1, 7.0, SQL*Plus, OLTP, OLAP, TOAD, SQL Developer, EM Grid control 11g and Cloud Control 12c, Dataguard, RAC, Physical and logical Standby, ASM, RAT, Goldengate, Exadata (Half rack), Peoplesoft, SQL Loader, data pump, External tables, Crontab, Flashback, RMAN, Oracle BI Admin, Discoverer plus & desktop, BMC remedy tool, FOGLIGHT, SQL Server 2008-14, SQLServerAgent, SQL Server Profiler

MDCONSULT, MARYLAND HEIGHTS, MO

May 2010 – Jan 2011

Oracle Database Administrator

MD Consult offers the most comprehensive information available in one convenient online resource. With instant access to full-text articles from over 80 medical journals and Clinics, 50 leading medical references across a wide range of specialties, clinically relevant drug information, and over 15,000 patient handouts.

Responsibilities:

Installation, configuration, maintenance and administration of Oracle 10g, 11g databases.

Involved in Analysis, planning, design, development, maintenance & administration of database systems.

Backup, restore and recovery strategies using RMAN, data pump & user managed techniques.

Involved in monitoring and administering RAC environment.

Monitor & performance tune database systems using SQL Plus, SQL Developer, OEM, TOAD.

Involved in development & maintenance of database objects.

Provided 24x7 on call support.

Maintaining database & application security concerning database access levels.

Configured Data Guard for application testing on multiple development and test databases.

Used MS Dynamics for maintaining & sharing project related information/documentation.

Environment: Oracle 9i, 10g & 11g, Redhat Linux 4, RAC (3 nodes), OLAP and OLTP, Grid control 11g, TOAD, SQL Developer, SQL Loader, Crontab, Putty, RMAN, SQL Server 2005, MS Dynamics, Erwin

ARIZCON CORPORATION, INDIA

July 2008 – Feb 2010

Database Administrator/Programmer Analyst

Responsibilities:

Involved in requirement gathering, planning, design & development and Administration of Oracle databases & database objects.

Performed backup, restore & recovery of the databases as per business needs.

Performance tune, database health check & environment monitoring using OEM Grid control, TOAD and SQL Developer for oracle database and SQL Profiler and Activity Monitor for SQL Server database.

Automate database tasks using shell scripts, SQL, PL/SQL & Crontab, SQLServerAgent (SQL databases).

Altered and developed procedures, and packages using PL/SQL.

Involved in shell script development for automating & scheduling database maintenance jobs.

Used data pump utility for import and export of data.

Initiated execution plan, Analyze query, etc to monitor and tune SQL query/report execution.

Involved in monitoring & administering Oracle databases in Production, development & test environments using Oracle Enterprise Manager (OEM).

Maintain & enhance database security concerning access level policies.

Coordinated with various teams/resources to effectively perform problem analysis and resolve them on-time.

Designed user interfaces using ASP.NET, HTML, Visual Studio .NET IDE, JavaScript and validation controls.

Installation & documentation of SQL Server 2000, Visual Studio .NET 2003 IDE.

Environment: Oracle 10g, Redhat Linux, Enterprise Manager, RMAN, TOAD, SQL Developer, Crontab, PL/SQL, Crystal reports, Visual Studio .Net 2003, SQL Server 2000, ASP.NET, MS Dynamics CRM, SSRS

Contact this candidate