ABDUL SHARIQ MOHAMMED

515-***-****

adixy6@r.postjobfree.com

* ***** ** ********** ** an Oracle Database Administrator / Systems Analyst with a demonstrated

history of working in the Information Technology and Services industry.

Skilled in providing 24x7 support for Development, Test, UAT and Production Oracle databases

(19c/18c/12c/11g/10g) on LINUX, AIX, Solaris and Windows platforms.

Excellent experience in OLTP/OLAP/DSS database systems, implementing and managing very large Oracle databases (VLDB) as huge as 40 TB.

Proficient in Database Administration activities; Patching, Database/Schema Cloning, RMAN Backup and Recovery, Performance Tuning, Capacity planning, Script development, and Documentation.

Experienced in Installation of high availability RAC environment (2, 3, 4 and 8 node clusters) and upgraded standalone databases to 10g/11g/12c/18c in non-RAC and RAC environments.

Proficient in installation, configuration, upgradation, migration and performance tuning of Oracle databases.

Experience in configuring Oracle Data Guard and GoldenGate between standalone and RAC databases.

Experience with OEM 13c infrastructure automation, database provisioning, and cloning.

GUI

Oracle Enterprise Manager (OEM) 12c/13c, Oracle Database Configuration Assistant (DBCA), Oracle Database Upgrade Assistant (DBUA)

Operating System

Linux (Red Hat, SUSE, OEL), IBM AIX, Oracle Solaris, HPUX, MS Windows (7/8.1/10)

Databases

Oracle 10g/11g/12c/18c/19c, SQL Server 2008 R2, IBM DB2, MySQL, Postgres, NoSQL, MongoDB, Netezza, Cassandra

Languages

C, C++, SQL, PL/SQL, UNIX Shell Scripting, .NET (C#), JAVA, Python

Tools/Utilities Used

SQL*Plus, iSQL Plus, SQL Loader, Server Manager, RMAN, StatsPack, AWR, ADDM, ServiceNow, MS Azure, Tableau, TKPROF, TOAD, Control-M, ServiceNow, Hummingbird, DBArtisan, IBM CDC, IBM Netezza, Jenkins, Bitbucket, JIRA, MS Azure, AWS

Master of Science in Computer Science, Texas A&M University-Commerce, Texas, USA

(2 years program, Jan 2014 – May 2015)

Bachelor of Engineering in Information Technology, Osmania University, Hyderabad, India

(4 years program, Jun 2006 – Jun 2010)

1)Department of Social Services – City of New York Nov 2017 – Present

Employer: Kastech Software Solutions Group, Texas - USA

Sr. Oracle Database Administrator

Responsibilities:

•Responsible for the creation and management of database instances; tasks include users’ creation, tablespaces’ management, tables, packages, functions, procedures, and configuring DB listener and services.

•Worked with application developers with requests involving code deployments, data replication, configuration, archiving of data, database refresh/cloning, database snapshots.

•Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like Oracle 12c, SQL Server, flat files to the Staging area, EDW and then to the Data Marts.

•Experience with OEM Upgrades and Migration from OEM 12c to 13c.

•Involved in requirement gathering, analysis, design, estimation and testing of different database projects.

•Designed, implemented and documented setup and maintenance of Oracle 12c Data Guard physical standby databases in high availability mode.

•Used Erwin for Logical and Physical database modeling of the warehouse, responsible for database schemas creation based on the logical models.

•Performed in-place database upgrades and migrations from Oracle 12c to 18c and 19c.

•Implemented Python scripts to automatically sync data between different storage server depending on current available space and remote location.

•Worked on data replication between Oracle and Netezza databases using Attunity Replicate.

•Designed, built new 13c Oracle Enterprise Manager on Solaris/AIX platforms.

•Automated database jobs using OEM Cloud 13c and Shell Scripting.

•Maintained and administered all Production/Test/Dev databases through OEM Cloud 13c, TOAD and SQL*Plus.

•Hands-on experience with Oracle Enterprise Manager (OEM) 13c including Management Agent setup, Oracle Management Console configuration,Dashboard setup and monitoring.

•Performance tuning of SQL queries using EXPLAIN PLAN, TKPROF, STATSPACK, ASH, AWR and ADDM to collect and maintain performance statistics and improving the database performance.

•Mentored and provided hands-on training to other database administrative staff including freshers.

Environment:

Solaris 11.3 SPARC, IBM AIX 6.1/7.1, RedHat Enterprise Linux 6.1, Putty, Oracle 10g/11g/12c/18c/19c, Datapump, Export/Import, Oracle Enterprise Manager (OEM) 12c/13c, 10g/11g Grid Control, DBArtisan, IBM CDC, IBM Netezza 7.0.2, Attunity Replicate 6.5

2)Department of Social Services – City of New York Mar 2016 – Oct 2017

Employer: VDriveInfo Inc., Texas - USA

Sr. Oracle Database Administrator

Responsibilities:

• Experience in installation and configuration of Oracle 11g/12c with RAC using ASM, configured user log on load balancing and failover (TAF) on RAC database for high availability.

• Extensive experience in performance tuning of database, memory & I/O using tools such as AWR, ADDM, STATSPACK and analyzing queries using EXPLAIN PLAN, SQL-TRACE, TKPROF.

• Extensive experience Installing, configuring, upgrading and performance tuning of Oracle 10gR2, 11gR1, 11gR2 RAC databases.

• Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases. Monitoring databases to optimize database performance and diagnosing any issues.

• Extensive experience in performing backups and tested crash recoveries using conventional hot, cold backups and RMAN.

• Responsible for monitoring environments using monitoring tool viz. Nagios, Check Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.

• Optimize postgresql.conf for performance improvement. Review all PostgreSQL logs for problems.

• Using Python developed solutions that are easy to deploy, maintain, and are bug free.

• Experience with OEM 13c System Configuration Baseline Implementation.

• Hands on experience of daily monitoring of Oracle instances and maintenance of databases using Oracle Enterprise Manager(OEM), Oracle GRID, ISQL*Plus, and SQL*Plus Command line scripts.

• Experience with Data Guard, creation of physical standby and resolving the physical standby database gap.

• Expertise in using Golden Gate to support data replication in the oracle database environment

• Worked on distributed database configuration, creation of database links and snapshots using STREAMS for 2 way replication of data.

•Configured 11g RAC with ASM on 2 nodes on HP Exadata.

• Extensive experience in setting up, administering, and performance tuning Oracle Golden Gate for data

replication.

• Experience in shell scripting used to set up various Cronjobs for automation of jobs.

Environment:

Oracle 10g/11g/12c RAC, Data Guard, Datapump, Export/Import, HP-UX v11i, Solaris 9.0/10.0/11.3 SPARC, Oracle Enterprise Manager(OEM) 12c/13c, 10g/11g Grid Control, Autosys, DBArtisan, MySQL, MongoDB, Webpack, PostgreSQL

3)Texas Comptroller of Public Accounts Jul 2015 – Mar 2016

Employer: Iconix Labs Inc., Texas, USA

Oracle Database Administrator

Responsibilities:

•Responsible for Database Administration of Oracle RAC 10g/11g and non RAC databases on ASM with size of databases varying from several GB to TB.

•Migrated database from Linux environment to AWS/RHEL Linux environment and used auto scaling feature.

•Managed Physical & Logical standby databases in RAC and non-RAC environments

•Worked on POC on OEM 12c Cloud, installed in all non–prod databases.

•Implemented 10g/11g/12c Data Guard with one physical database

•Implemented 11gR2 Data Guard using RMAN duplicate.

•Worked with Control-M scheduler in UNIX environment.

•Generated Dashboards using Tableau with quick filters, parameters and sets to handle views more efficiently.

•Configured 11g RAC on ODA Oracle Database Appliance.

•Managed Oracle Grid control 11.1.0.1 and configured Data Guard for OMR in Linux environment.

•Experience with database patching using patch management plans through OEM.

•Performed Oracle database upgrade from 11gR1 to 11gR2 in Linux RAC environment.

•Extensively used AWR, ADDM, ASH reports for database performance statistics.

•SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.

•OEM 12c installation and configuration for monitoring and performance tuning.

•Implemented Data Guard and GoldenGate for high-availability and replication.

• Migrated and upgraded database instances from Oracle 10g to 11g – Standalone and RAC databases.

Environment:

AIX 6.1/7.1, Oracle 11g/12c RAC, Data Guard, DataPump Export/Import, Oracle Enterprise Manager (OEM) 12c, 11g Grid Control, MySQL, Tableau 9.2

4)Texas A&M University-Commerce, Texas - USA Aug 2014 – May 2015

Graduate Assistant / Web Developer

Responsibilities:

•Developed console based applications using Visual Studio 2012.

•Made web changes for the university’s Research portal, and also helped resolve any issues/bugs reported by users.

•Developed Research application PDF forms in Adobe Acrobat Pro using MS Excel, JavaScript and VB.NET

•Installed, administered and updated Oracle database tools and systems.

•Processed the research applications of faculty & students, and indexed the records in Fortis database.

•Instrumental in preparing IRB, IACUC and IBC materials for submission to funding agencies and foundations.

5)Accenture, Bangalore - India Jul 2010 – Oct 2013

Software Engineering Analyst

Responsibilities:

Deeply involved in the database Administration of Oracle RAC 9i/10g/11g and non RAC databases on SFRAC with size of databases varying from several GB to TB.

Managed Physical & Logical standby databases in RAC and non-RAC environments.

Engaged with the development and production support teams; handling and troubleshooting business critical issues pertaining to various web based applications of the client.

Worked effectively on various helpdesk tickets/issues and business requests, to help resolve client’s issues/requests within the given timeframe with zero defect impact.

Involved in performance tuning of database, memory & I/O using tools such as AWR, ADDM, STATSPACK and analyzing queries using EXPLAIN PLAN, SQL-TRACE, TKPROF, TOAD, SQL Developer.

Involved in identifying the bugs in the applications, and deploying the code fixes in production environment.

PL/SQL, Performance Tuning, Application Tuning and Monitoring.

Involved in providing knowledge transfer sessions to peers about the different applications that we support, and the ways of troubleshooting the issues in production.

Instrumental in making development changes in the applications, per the business request from the client, testing the functionality, and then deploying it into the production environment.

Environment:

.NET Framework 3.5/4.0 C#, Oracle 11g, Windows Server 2003/2008, MS Visual Studio 2008, SQL Server 2008 R2, Java, NoSQL, Github, HTML

MCPD: 70-519 (Designing & Developing Web Applications using .NET Framework 4.0)

Oracle Certified Associate

- Oracle Cloud Infrastructure 2019 Cloud Operations Associate

- Oracle Cloud Infrastructure Foundations 2020 Associate

Oracle Certified Specialist

- Oracle Autonomous Database Cloud 2019 Certified Specialist

Microsoft Certified Technology Specialist

- Web Applications Development with .NET Framework 4.0

- Accessing Data with .NET Framework 4.0

- Windows Communication Foundation Development with .NET Framework 4.0

- Windows Applications Development with .NET Framework 4.0

Microsoft Certified Professional Developer

- Web Developer 4

Accenture - Certified Retail Industry Generalist

PROFESSIONAL SUMMARY

SKILLS

EDUCATION

PROFESSIONAL EXPERIENCE

CERTIFICATIONS

Contact this candidate