Curriculum Vitae

ANUSURI SAI SUNIL Email : ad0ron@r.postjobfree.com

Oracle DBA With AWS Cell : +919*********.

●Having a 8 years of IT experience and 7.5 years of experience as an Oracle DBA supporting Prod/QC/Dev/Stage environments.

PROFESSIONAL SUMMARY

●Migrating the schemas, tables to AWS RDS

● Worked on resolving the master password issue in AWS for the RDS instances.

●Upgrading databases in AWS RDS from 12 to 19c

●Experience working with Oracle versions11gR1/2 in a Linux, Solaris environment.

●Administration of Oracle 11g & 12c Oracle Database Architecture including the latest version of Oracle.

●User Creation, granting and revoking the appropriate privileges and roles.

●Experience on performing backup and Refresh using Export/Import and Data pumps.

●Experience in handling complex database recovery scenarios with Backup and Recovery using Oracle Recovery Manager (RMAN).

●Perform Database cloning using RMAN/Data pump

●Performing Point-in-time recovery using RMAN and Database overwrite.

●Having Experience on upgrading different versions of databases i.e. from 11 to 12.

●Configure Data guard setup for standby databases and fix the log shipping issues.

●Working Experience in Data guard switchover activity.

●Configuring the RMAN database backups in Solaris and Linux.

●Experience in good change control process with proper documentation and worked with change management tools like Service now and BMC Remedy.

●Working knowledge on Linux Environment supporting various versions of oracle Databases.

●Experience as Oracle Database Administrator, worked in highly critical Health care support environment which involves high privilege restricted SOX Database accounts.

●Work closely with several teams (Finance/Application/Storage/SA/Network/Offshore) on several issues and day to day support.

●Providing feedback to new joiners & mentoring team members and helping they understand the process.

●Experience in production and other environments handling different applications with 24/7 support

PROJECT:

Newt Global is a leading global Information Technology and Consulting company which focuses on Cloud Enablement, DevOps Transformation, Digital Initiatives, and Automation. Newt Global harnesses the power of Cloud, DevOps and emerging digital technologies integrated into a versatile platform, to help clients become productive and competitive

Roles & Responsibilities:

Worked on creating the procedures, functions and packages, for our internal tool DMAP to enhance the new features for capturing the statements.

Worked on the procedures which doesn’t have any out parameter.

Worked closely with developers in setting up their database environment locally.

Configured unified audit trail to see whether all the statements executed in that particular session has been recording or not .

Worked on creating the database in docker environment, edited the scripts for configuring the archive log .

Responsible for managing and optimizing the Postgres database infrastructure including setup, configuration, security, backups, monitoring and performance tuning.

Administer user access, activity monitoring, security, auditing and permissions for database accounts and roles

Maintaining the database schema, including creating new tables, adding columns to existing tables

deleting unnecessary tables and data Performing regular scheduled maintenance on the database server, such as vacuum analysis on large tables to remove obsolete data Proactively

Monitoring database performance to identify slowdowns or potential issues.

PROJECT:

Client

Pfizer

Role

Database Consultant

Organization

Infosys

Duration

January 19 2022 to October .

Tools

Putty, Toad, Service Manager

Environment

Languages : SQL

Database : ORACLE, postgres AWS RDS, EC2

O/s : Red Hat Linux/Unix,

Roles & responsibilities :

Worked on Aws RDS and Aurora instance flavours of Oracle and Postgres .

Upgraded the instance classes.

Addition of storage in rds instances whenever there is space crunch issues.

Doing a refresh through PGADMIN tool from dev to test and viceversa in postgres.

Creating the roles and granting them appropriately to the users in Postgres .

Deployment of scripts in production with appropriate change approvals.

PROJECT:

Farm Credit Canada Database Support, Oracle DBA

Client

Farm Credit Canada

Role

Database Consultant

Organization

TCS

Duration

April 2021 to January 17 2022.

Tools

Putty, Toad, Service now

Environment

Languages : SQL

Database : ORACLE postgres AWS RDS, EC2

O/s : Red Hat Linux/Unix, Solaris

Roles & responsibilities:

Doing a dry run before migration and giving a estimation how much time it would take for the migration.

Migrated Oracle databases from on prem to Amazon RDS Oracle.

Creating IAM roles in AWS.

Adding S3 to RDS and EC2 in AWS.

Refreshed the schemas from one RDS Oracle to another RDS Oracle .

resolving the master password issues.

Hands on experience in goldengate.

Create objects in DDL commands with redshift.

Data encryption in redshift cluster.

Tagging resources in redshift cluster.

upgrading the databases in RDS .

taking the snapshot of the databases .

creating users in Postgres giving appropriate roles through DBeaver.

pulling, updating and rolling back the code to database from GitHub and liquibase.

PROJECT:

GlaxoSmithKline Database Support, Oracle DBA

Client

Glaxo Smith Kline

Role

Database Administrator

Organization

Tech Mahindra

Duration

April 2015 to March 2021

Tools

Putty, Remedy, Zero touch, Service Catalog

Environment

Languages : SQL

Database : ORACLE 9i /10g/11g &12

O/s : Red Hat Linux/Unix, Solaris

Roles & responsibilities:

Creating database users and by setting the default & temporary table spaces, assigning quotas, roles, privileges and profiles to users.

Schema level refreshes using Expdp/Impdp.

PTR (point-in-time recovery through) COLD and RMAN.

Taking scheduled backup as per backup strategy using RMAN.

Check backup and archive log availability with the help of crosscheck.

RMAN cloning.

upgrading from 11g to 12c.

applying the PSU patches.

Setting up the DR, resolving the sync issues .

Availability to 24x7 on-call support on rotation basis for Production and Development systems.

PROFESSIONAL EXPERIENCE

Current Organisation : Newt Global

Period : October 2022 to March 2023

Role : Senior Database Administrator

Previous Organization : Sydata Consultancy

Period : January 2022 to October 2022

Role : Senior Software Engineer

Previous Organization : Future Focus infotech

Period : April 2021 to January 2022

Role : Software Engineer DBA

Previous Organization : Tech Mahindra

Period : April 2015 – March 2021

Role : Database Administrator

ACHIEVEMENTS

Awarded the “BRAVO” and “Pat On Back” for my outstanding work from TechMahindra.

EDUCATION & CREDENTIALS

Degree in Gitam Deemed University with 70%

Diploma in EEE, with 75% from Sai Ganapathi Polytechnic, Visakhapatnam.

S.S.C (2010-2011) from Board of Secondary Education with an aggregate of 82%.

TECHNICAL SKILL SET

Operating Systems : UNIX, LINUX, Sun OS, AIX, Windows 7, Windows 10.

Database : Oracle 10g, 11g and 12c, postgres, AWS RDS, AWS EC2.

Tools & Utilities : VM Ware, MS Office, Data Pump, RMAN, ASMCMD, Putty, Toad,SQL Developer, Winscp, Patrol, Zero Touch, Remedy, Pandora.

Other Skills : Knowledge on Goldengate, AWS

PERSONAL DOSSIER

Name : Anusuri Sai Sunil

Date of Birth : 20th December, 1995

Linguistic Abilities : English, Telugu

DECLARATION

I hereby declare that the all the information furnished herein are true and correct to the best of my knowledge and belief.

(ANUSURI SAI SUNIL)

Contact this candidate