SUMMARY:

• Oracle Certified Database Administrator with over 9 years of experience on Linux, UNIX and Windows platforms for Oracle (10g, 11g, 12c). 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 Cluster, Data Guard, ASM, Goldengate, OEM 11g, Cloud Control 12c, performance tuning, backup, capacity planning for Oracle database environments.
• Experienced in SQL Server databases (2000 - 2014).
• Extensive experience in developing database objects using SQL, PL/SQL, T-SQL.
• Involved in all phases/steps of Project, including requirement gathering, planning, design, implementation, testing and deliverables.
• Experience working with RMAN, DataGuard, Goldengate, Standalone, RAC, GRID, ASM , datapump utilities, SQL Loader, External table .
• 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.
• 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.
• Experience in creating the reports/dashboard in OBIEE ( Oracle Business Intelligence), crystal reports, and Discoverer.
• Knowledge of MySQL, MongoDB, Exadata, NAS, SAN, AWS.
• Experience working SDLC in web development environment with Microsoft technologies (.NET, C#, ADO.NET, SQL Server ).
• Strong knowledge of VMware technologies (ESX, ESXi, Hypervisor1, 2, etc. ), Domain controller, DNS, Active directory, DHCP.
• Knowledge of web & windows based software application development using Microsoft visual studio .NET, eclipse.
• 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.

TECHNICAL SKILLS:

Operating System: UNIX, RHEL 4, 5, IBM-AIX 5.3, 6.1, 7.0, Solaris, Windows, NT/XP

Programming Language/Technologies: SQL, PL/SQL, Shell script, JavaScript, C#, ASP.NET, T-SQL

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

Software Packages: MS Office, Visio, SharePoint, MS Dynamics CRM

Source Control: Visual SourceSafe, TFS

PROFESSIONAL EXPERIENCE:

Confidential, AUDOBON, PA

Oracle Database Administrator

Responsibilities:

• Involve in monitoring & tuning database systems & SQL performance.
• Grid Infrastructure software installation & configuration, for ASM migration .
• Looking into implementing database lifecycle management attributes (database patching) using cloud control 12c.
• Involved in verifying access control policies for d atabase accounts .
• Development & maintenance of database objects .
• Data migration using datapump technologies.

Environment: Oracle 10g, 11g, 12c, AIX, Linux, SQL*Plus, OLTP, OLAP, TOAD, SQL Developer, Cloud Control 12c, Database Lifecycle Management pack, Dataguard, RAC, ASM, SQL Loader, datapump, Crontab, RMAN

Confidential, KANSAS CITY, MO

Oracle Database Administrator

Responsibilities:

• Implemented database lifecycle management attributes (database patching) using cloud control 12c.
• Build dataguard for geographically dispersed systems.
• Involved in database upgrades & patching (11.2.0.1 - 11.2.0.4 ) .
• Create & administer access control policies for d atabase accounts (implemented PL/SQL process) .
• Development & maintenance support for database objects .
• Involve in monitoring & tuning database systems & SQL performance.

Environment: Oracle 10g, 11g, 12c, AIX, Linux, SunOS, SQL*Plus, OLTP, OLAP, TOAD, SQL Developer, Grid control 11g, Cloud Control 12c, Database Lifecycle Management pack, dataguard, RAC, ASM, SQL Loader, datapump, Crontab, RMAN, BMC remedy tool

Confidential, NEW YORK

Oracle Database Administrator

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 of 12c databases (CDB, PDB).
• Monitoring & administration of Oracle Applications environment (RAC & Data Guard).
• Involved in backup, backup validation, restore, & recovery strategies ( RMAN, User managed ).
• 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.
• Used SSMS, SQL Server Agent (scheduling), SQL Server profiler & tuning advisor.
• Create on demand database objects for SSRS, SSIS & SSAS development.
• Migrate, monitor & administer oracle instances to ASM storage .
• Migrate databases to Exadata, NONASM to ASM, cross platform.
• Involved in dataguard environment implementation for Disaster Recovery purposes .
• Installation, configuration, monitoring, maintenance and administration of Goldengate environment.
• 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, AIX, SQL*Plus, OLTP, OLAP, TOAD, SQL Developer, Grid control 11g, Cloud Control 12c, Dataguard, RAC, 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, SQL Server Agent, SQL Server Profiler

Confidential, MARYLAND HEIGHTS, MO

Oracle Database Administrator

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, Red hat 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

Confidential

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 , SQL Server Agent (SQL databases).
• Initiated execution plan, Analyze query 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.
• Used data pump utility for import and export of data.
• 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, Red hat Linux, Enterprise Manager 10g, RMAN, TOAD, SQL Developer, Crontab, PL/SQL, Crystal reports, Visual Studio .Net 2003, SQL Server 2000, ASP.NET, MS Dynamics CRM, SSRS

Confidential

Technical Support Associate

Responsibilities:

• Provided support for database applications, desktop/laptop installations & configurations, IIS server, Windows OS installation & configuration, Active Directory & Domain Controller installation & configuration.
• Developing & modifying SQL scripts , for database objects (tables, views, MVs, stored procedures)
• Involved in requirement gathering, planning, design & development of database applications.
• Provide on-call support for database applications/products, to international clients.