Mobile: 851******* / 959-***-****

E-mail: ad3ekp@r.postjobfree.com ; ad3ekp@r.postjobfree.com

SUMMARY

I’m Computer Science Engineering graduate, Oracle Certified Professional, Certified Cloud Architect, Certified Specialist in Cloud Database Migration and Integration 2021 and Oracle Autonomous Database Cloud 2019 Certified Specialist with more than 21 years of experience in different IT and FMCG industries as an Oracle DBA, Cloud DBA, Apps DBA, MS SQL DBA, PostgreSQL DBA, DevOps and DBA Head.

Expert in Database Migration, Administration, Provisioning, Patching, backup and recovery of different databases on different Clouds (OCI, AWS & NTT/Netmagic ) and On-premise.

Creation, configuration and management of Oracle RAC, Golden gate, Physical Standby DB, Snapshot and Active Datagaurd from 11g to 19c including PDB/CDB, Autonomous DB and Exadata (X8M-2).

Very Good in Performance Tuning of Database, SQL queries, Application Server, OS level tuning and writing shell scripts in UNIX, Linux, Python and scheduling cron jobs.

Deployment of Forms/Reports, Java and ADF Applications in DevOps way using Ansible, svn, cvs, Git/Git Hub, Virtual Box, Docker, Veracode and Teraform CI/CD tools.

Capacity planning for New S/W and H/W to complete new business requirements (New projects).

Managing different projects and different resources by coordinating with different departments and vendors to complete new business requirement.

Worked as a Project Lead/Team Lead for Global clients like GE Money Singapore, GE SBI, Zerox Capital Services-USA, Neustar-USA, Verizon Business (VDSI) and Excise & Taxation Dept, Punjab Government-India.

Trained many external and internal people for different skills e.g. OCI (Oracle Cloud), DB migration, Tuning etc.

PROFESSIONAL CERTIFICATIONS AND TRAININGS

Oracle Cloud Database Migration and Integration 2021 Specialist.

Oracle Autonomous Database Cloud 2019 Certified Specialist.

Oracle Cloud Infrastructure 2019 Architect Associate (OCI Architect).

Oracle Cloud Infrastructure (OCI) Foundations 2020 Associate (OCA).

Oracle Database 10g Administrator Certified Professional (OCP).

Oracle Database 10g Administrator Certified Associate (OCA).

Oracle Database SQL Certified Expert (OCE).

Certification in MEP (Managerial Effective Program) 6 months program.

Done Oracle Cloud DBA, DevOps, Containerization and OCI training from K21 Academy.

TECHNICAL SKILLS & ACTIVITIES PERFORMING:

Cloud DBA Activities/Cloud computing: Oracle 12c, 19c Databases and Autonomous Database. Provisioning, Patching, Managing Backup, monitoring and cloning DBs. Managing ML user, Identity and Access management (IAM). Managing & Performance tuning of Exadata, uploading data into cloud ADW & ATP DB and managing applications which are under SAAS & PAAS. Managing AWS RDS, EC2 instances, Database migration on AWS using DMS and datapump. Integration of Cloud Applications.

Oracle Database (19c/12c/11g): Installation and Administration of RAC (11gR2), Data Guard (physical standby), Active Data guard and snapshot Data Guard. Grid, ASM, OEM, Data security, TDE, applying patches, Capacity planning, Performance Tuning of Database and SQL tuning. Database backup (RMAN/datapump), restoration and ensuring auditing policies.

Oracle Fusion Middleware: WebLogic Server 12c/14c Design, Installation, Deployment, Configuration of WebLogic Server (12c R2 and R1). Upgrade of Fusion Middleware applications from 12.1.1.0 to 12.2.1.3. ADF Application deployment, Configuration and Load balancer for high availability including Integration with Business Applications and Identity Management components.

Oracle HTTP Server & SSL (12c/11g): Installation/Configuring of HTTP Server and virtual host with load balancer, configuration of WebCache in cluster and configuring OHS servers and providing Security, SSL configuration (Secured socket layers) for WebLogic ERP, masking and redirection of application URL.

Servers Administrations: RHEL 7.*, 6.*, 5.*,SUSE, Ubuntu, UNIX. Installation, configurations and administration of Linux servers which are used by our Databases and Applications. Monitoring servers and Applications using Git/GitHub, Ansible, Teraform and writing and scheduling cron jobs/script according to business requirement.

EXPERIENCE DETAILS

Aug 2011 to Till Date

D S Group Ltd, Noida

Position: Assistant General Manager (DBA Head) -- (2017- till Date)

Position: Senior Manager -- (2011- 2017)

Team Size- 20 +

Roles and responsibilities:

Clouds: Provisioning, Patching & Administering Oracle 12c to 19c including Autonomous Database & MS SQL server 2017/18/2020 on different clouds like OCI & AWS.

Migration of Database on AWS using DMS and datapump and on OCI using RMAN, datapump & ZDM.

On-Premise: Installation, configuration and Management of Oracle 11g R2 & 12cR2, MS SQL Server 2020, RAC Databases, Golden Gate, Standby DB, Snapshot Standby, Active Data Guard on Linux 6/7*. Managing Gird, ASM & different backups.

Managing Exadata (X8M-2), IAM users and uploading data into Oracle Autonomous Database for ML users to generate reports.

Installation, configuration and Management of Oracle Fusion Middleware WebLogic 12c, http/https (OHS) for Forms/Reports, ADF and Java Applications and applying SSL certificate.

Creating and Managing data source, node manager, OHS and web connections.

Deployment/release and source code management of applications using Git/GitHub, CVS, CI/CD, Ansible .

Performance Tuning of Exadata, SQLs, Databases, Applications and Database Servers (OS Level).

Capacity planning for new projects/ requirement for H/W, S/W.

Managing different projects and different resources by coordinating with different departments and vendors to complete new business requirement.

Directly managing team of DBAs and functionally using DBA, development, functional and support team.

Writing shell scripts for monitoring of different servers, DBs and Applications by using Ansible and cron jobs.

Managing SAP application, assigning Roles, T-codes and resolving SAP’s end users’ problem.

Mentoring & training to DBAs and Developers on Database, SQL tuning and Application tuning.

Working with different Vendors, Clients and Auditors to complete the business requirement.

Environment:

Operating Systems: RHEL Linux 6.*, 7.*, Ubuntu 2016/2020 and SUSE Linux 16.

Databases: Oracle 11g R2 RAC, Oracle 12c, 19c Autonomous Database, Multitenant DB, Physical Standby, Active and snapshot standby DBs and M.S. SQL server 2020 database.

Apr 2009 – Aug 2011

Infinite Computes Solutions, Chennai - Sr. Oracle DBA

Client: Neustar Inc (Apr 2009 –Mar 2008)

Client: Verizon Business Development Center, Chennai (Apr 2009 –Mar 2008)

Team Size -15

Roles and responsibilities:

Database installation, creation, migration /upgradation and cloning.

Creating and Setup Standby/Data Guard database,MV, DB link and Database Jobs and to scheduled them in cron jobs or on database level.

Responsible for RMAN and Export backup activities. Database health checkup (locks, session, cursor, processes, alert log, and trace file).

Tuning of the DB with different parameters for max performance and mentoring to other teams on same.

Tuning/optimizing high cost SQL statements by database and form AWR report.

Monitoring production and Standby database and its servers using Grid Control utility.

Creating triggers and procedures to complete the client’s request.

Environment:

OS: Unix AIX 5.2, 5.3, Linux 3.4,5.6.8.910,SunOs/Solaris 5.9,10

Databases: Oracle 9i, 10g and 11g. Both OLTP and OLAP databases and Datagaurd and streaming.

Mar 2007 2007 – Mar – Apr 2009

Birlasoft Ltd Noida- Sr. S/W Engineer (Oracle DBA)

Client: GE Money APAC (Mar 2008)

Client: XCS (Xerox Capital Services) (Mar 2008 – Apr 2009)

Roles & Responsibilities:

Database installation, configuration, migration/upgradation, cloning and patching.

Scheduling jobs on database and Linux server level.

Database health checkup (session, cursor, processes, alert log, and trace file) and Space Management.

Responsible for RMAN backup activities, performance monitoring & Database Tuning (Objects/schema analysing, index creation & rebuilding, SQL- trace, stats pack report).

User management (Creation, privileges, Roles etc.) and any time if any error occurs, to resolve that.

File deployment, script execution on database servers.

Environment: AIX 5.3,SunOs 5.9, ETL Tools (OWB), Oracle 9i and 10g Both OATP and OLAP databases.

OCT 2006 – MAR 2007

CMC Ltd: S/W Engineer (Oracle DBA)

Client: Excise Taxation and Tech Service Agency (ETTSA) - Government of Punjab.

Roles & Responsibilities:

Database installation, creation.Database health check up (session, cursor, processes, alert log, and trace file).

Configuration & recovery of physical standby database and Space Management (Table space/ Objects).

Backup Activities (Export/Import, Online Backup, cold backup). Archive files & Full Physical backup by BrightStor Enterprise Manager.

Performance monitoring & Tuning ( analyzing objects, index creation & rebuilding, SQL- trace, stats pack report).

AIX activities (L.V. creation, service management, WSM observation, topas observation)

User management (Creation, privileges, Roles etc.).

Report generation, file deployment, script execution on prod database server.

Environment: AIX 5.2, Oracle 9i RAC Database, Physical Standby Database.

Jan 2006 – Oct 2006

Progressive Computech Services: At the franchise of Wipro Infotech.

Client: Bharat Petroleum Corporation Ltd. (BPCL) at Greater Noida.

Roles & Responsibilities:

Configuration & recovery and monitoring of physical standby database.

Database health check up (session, cursor, processes, alert log, and trace file).

Space Management (Table space/ Objects.Any time if any error occurs, to resolve that.

To check the database connectivity and speed at the different location of the BPCL in India.

Creating and managing user accounts.

Environment: Oracle 9i, AIX 5.2, SAP.

Feb 2003– Dec 2005

e-Solutions as Jr. DBA

Roles & Responsibilities:

Database health check up (session, cursor, processes, alert log, and trace file).

Database and System level space Management.

Providing information to onsite managers regarding contact numbers, address etc.

Any time if any error occurs, to resolve that.

To check the database connectivity with the application.

Environment: Database Oracle 9i, SunOs 5.9

Jun 2002 – Jan 2003

Digicare Softech (P) Ltd: Software and Web Developer

Client: Chronicle Publication System

Description:

The software designed in this project was developed to provide automatic billing, challan, reports and any Information about the magazine .It keeps all the records of company & its clients. This program was made using VB and Oracle 9i.

Environment: O/S: Window 2000, VB 6.0, And Oracle 9i.

PANELS, SYSTEM STUDIES & MENTORSHIP:

I involve in various technical studies, prototype development and technical presentations from IT Team.

Panel member for technical recruitments in DS Group Ltd and Infinite Computer Solutions.

Time to time scheduling sessions for New initiatives, Database and SQL Tuning training for DBA and Developers, Functional and other teams.

AWARDS/APPRECIATIONS:

Award of proud owner of a Certification role by Oracle University.

Award of Member of the Oracle University (OU) Community.

Best Employee of The Month in Birlasoft for the month Oct 2007.

Best team member of the month in Birlasoft for the month Jan 2008.

Best team member of the month in Birlasoft in the month Jan 2009.

Best performer award in the month of Aug 2010 in Infinite Computer Solutions.

EDUCATIONAL QUALIFICATIONS:

Bachelor of Engineering (B.E.) in Computer Science & Eng from CCS Univ. Meerut (U.P.) in 2002 with 70% marks.

B.Sc-II (Maths) From Dr. Ram Manohar Lohiya Univ Ayodhya, U.P. in 1998.

Intermediate from U.P. Board Allahabad in 1994 with 55 %.

High School from UP. Board Allahabad in 1992 with 69.2 %

PERSONAL DETAILS

Name : GIRIJA SHANKER

Date of Birth : 1st May 1977

Father’s Name : Shri P. R. Yadav

Nationality : Indian

Marital Status : Married

Permanent Add : PO- Atraulia, Dist - Azamgarh, U.P. -23223

Contact No. : 095**-****** / 851**-*****

Date: 16/11/2023

Place: Noida (Girija Shanker)

Contact this candidate