B K RAJU

E-Mail:adwinu@r.postjobfree.com Mobile: 91-950******* EXPERIENCE SUMMARY

Solution Architect with Database Administrator with progressively responsible positions in diversified and very large production and development environments with database implementation and development activities in various platforms such as UNIX, Solaris, Red Hat Linux, Windows.

• Experienced in leading and managing diverse multi-cultural teams of 23 people in stressful 24/7 environments, prioritizing deliverables, and optimizing resource utilization across projects to accomplish targeted goals and assure that Service Level Agreements SLA are fulfilled.

• Implemented auditing activities provided by Drift Management to assist in keeping the data center operationally compliant with the business rules and establishing a baseline with the security configuration.

• Implemented the ever-growing database of gap signatures that help organizations avoid configuration drifts.

• Implemented TDM with masking production data—sometimes sub-setting it—and moving it to non-production environments for use in testing with Data Privacy for large clients using CA Data Maker etc.

• Experience in designing architecture, planning and deploying RAC with Transparent Application Failover TAF environments along with Cache Fusion and Flashback technologies for high availability and zero downtime.

• Provided technical assistance for development of physical and logical architecture models on all Oracle server platforms

• Good experience in Shell Scripting and Python.

• External loading and integration of data using ODI (Oracle Data Integrator).

• AWS administration EC2, RDS, VPC, S3, IAM, Creating policies and rules, Cloud Watch, Metrics alert configuration etc..

• Database version control and data management experience using DBMaestro, Liquibase, Delphix and CA TDM. SOFTWARE SKILLS:

Operating Systems: Linux, Sun Solaris, Windows and IBM AIX. Languages: SQL, PL/SQL, Shell Scripting and Python. RDBMS: Oracle (9i,10g,11g,12c,19c), MS-Access, Microsoft SQL server, MYSQL. Tuning Tools: Oracle Enterprise Manager (EM), DBVERIFY, LOGMINER, TKPROF, SQL*Loader, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and SQLT. Utilities: SQL* Loader, EXP, IMP, EXPDP, IMPDP, TOAD, Oracle Enterprise Manager, OPATCH, RMAN, SQLT. Database Version Tools: Liquibase, DBMastro, Delphix. Tools: Puppet, Chef, Ansible, AWS CloudControl, DriftGuard, UpGuard, CA Data Maker, SQL Developer, My Sql Workbench.

QUALIFICATION: B-Tech in Electronics and Communication Engr from VITAM, Vizianagaram affiliated by JNTU University in 2005.

CERTIFICATION: Oracle Database 10g: Administration I PROJECT EXPERIENCE:

Client : Micron CPG

Role : Solution Architect / Database Admin & Analyst Period : Nov 2020 to Till Date

Technologies : Oracle, Microsoft SQL server, Mongo, MySQL etc... Environments : Amazon AWS EC2, RDS

Responsibilities:

• Administration of Cloud EC2 & RDS Database Instances (Microsoft SQL Server, Oracle)

• Worked with other technology Vendors to build solutions as per the Business Needs.

• Lead & Conduct Solution presentations, demonstrations and Implementations

• Subject Matter Expert in the development of Microsoft & AWS cloud solutions storage, Automation, Compute & Third-Party Vendor Tools

• Developed the Search Engine using Stored Procedures, Functions, Triggers etc. with inbuilt functionality of the Microsoft Full Text Search Engine

• Implementation of ETL through SSIS.

• Responsible of handling the Data Engineer through automation from different sources and generated the reports through BI tools.

2

Micron Confidential

Micron Confidential

B K RAJU

• Performance Tuning at Instance level as well as the Query level tunning.

• Developed and implemented the entire Architecture of the Environment in a well-organized way.

• Implemented the Automation in handling the objects in the database which is having dependencies with the Third-Party tools.

Client : : American Airlines (Caprus IT solutions) Role : Sr Architect

Period : Nov 2017 to Nov 2020

Technology : Oracle 11gR2, 12C, 19c, Mongo, Microsoft SQL Server and MySQL on multiple OS and RDS. Languages : SQL, PL/SQL.

Team Size : 15

Operating System: Oracle Linux 6.7, RHEL 6.0,6.2,6.5,7.1 & WINDOWS Tools : Liquibase, DB Maestro, Puppet, Chef, Ansible, Oracle, AWS Cloud Control, Drift Guard & Up Guard, CA Data Maker, MySQL Workbench, PL/SQL, RMAN, SQL Developer. Responsibilities:

• Implemented the management of infrastructure changes in your data center IT environment.

• Implemented auditing activities provided by Drift Management to assist in keeping the data center operationally compliant with the business rules of IT environment.

• Implemented the ever-growing database of gap signatures that help organizations avoid configuration drifts.

• Implemented scripted collections to find configuration drift in non-data & non-file-based databases and migrated the configurations from on-premises to cloud deployments.

• Implemented the entire IT infrastructure visibility and automates compliance and configuration drift management.

• Worked as a Technical Lead with hands on and executive advisor for the several project state holders and C level, responsible for the design, implementation, and capacity planning of database systems for the Banking project utilizing Oracle's newest and advance technologies for both RAC and non-RAC environments, single node RAC, and oracle restart, RMAN, ASM, Grid Infrastructure GI, OEM 12c, Golden Gate and AWS administration.

• Responsible for day-to-day advance support for the High Availability Environments: multi-node RAC and DR Disaster Recovery Site systems utilizing Oracle's physical and Logical Standby Databases Data Guard strategies.

• Creating IAM roles, policies, groups, S3 integrations, Certification upgrades and VPC configuration for all Oracle RDS instances in different regions.

• Implemented master and slave configuration for the banking project for the MySQL database

• Performance tuning Instance as well as SQL level tuning and done business logic implementation by writing views, Functions, procedures, triggers and packages.

• Implemented TDE (Column Level and Tablespace level) encryption with wallet and DB vault.

• Replications of parent and slave environments for MySQL databases.

• Experience with managing database changes and data management using DB Maestro.

• Data Masking using CA Fast Data Masking for Production to Lower environment copy

• Data Sub-setting using CA Data Maker to Copy data from Production to Staging environments

• Gold Copy design and legacy data synchronization using CA Data Maker Company : JPMorgan

Role : Sr Oracle DBA

Period : Nov 2016 to Nov 2017

Databases : Oracle & Microsoft SQL server, Mysql, Mongo Languages : SQL, PL/SQL, Shell Scripting and Python. Team Size : 15

Operating System: RHEL 6.0,6.2,6.5,7.1 & WINDOWS

Responsibilities:

• Assisted in management and database administration of Oracle database applications on Exadata platforms.

• Implemented the management of infrastructure changes in your data center IT environment.

• Implemented auditing activities provided by Drift Management to assist in keeping the data center operationally compliant with the business rules of your IT environment.

• Provided technical assistance for designing, installation and upgrading of databases.

• Maintaining and Troubleshooting the Real Application Cluster environments with DR setup.

• Performance tuning instance as well as SQL tuning.

• Backups restore and recovery with ZDLRA configured on Exadata server.

• Managing DR environment for different servers with GOLDEN GATE with Heterogeneous environment with MySQL database.

3

Micron Confidential

Micron Confidential

B K RAJU

• Performing Schema level/Full DB Refresh using EXP, IMP, EXPDP and IMPDP.

• Applied different types of Bundle patches as well as interm patch for different databases for different versions.

• Implemented the change request as per the request from the application team.

• Golden gate configuration and maintenance

• Upgradation and migration manually and using Amazon RDS. Company : XOOT ACCESS TECH PVT LTD (Sutherland Global Solutions Pvt Ltd) Role : Sr Associate

Period : April 2012 to NOV 2016

Environment : Oracle 10g & 11gR2, 12C on Linux, Windows (2003, 2008R2, 2012), OEM12C, PL/SQL, RMAN, TOAD, SQL NAVIGATOR, SQL Developer.

Languages : SQL, PL/SQL, Shell Scripting.

Databases : Oracle, MYSQL and SQL Server.

Team : 23

Operating System : RHEL 6.0,6.2,6.5 & WINDOWS

Responsibilities:

• Provide the SME service for the clients who are using the Oracle databases from version 10G,11G and 12C RAC with Multi-tenant architecture (CDB and PDB) having DR configured and implemented Database Vault.

• Implemented Test Data Management for biggest EHR application used across the globe.

• Data Masking validation automation for source and target databases using different tools like CA and Oracle.

• DB Lead Architect Consultant responsible for the design and implementation of 10gR2 to 11gR2 migration for all corporate databases for both RAC and non-RAC environments in AWS and RACKSPACE Cloud Environments.

• Managed day to day activities and overall architecture of the entire database infrastructure environment: capacity planning, configuration and integration of several database and components

• Launched & managed the instances in Amazon EC2 environment and taking the snapshots of the instances and performed the storage management in AWS by creating and adding the volumes for different OS.

• Performance tuning for the complex queries using different tools like SQLT and techniques without disturbing the production environment.

• Deploying agents in the production database for the monitoring the databases.

• Upgraded from Oracle Database 11.2.0.3 to 11.2.0.4 and OEM 12.1.0.1 to 12.1.0.4 and also configured OEM 13C

• Applied different types of Bundle patches as well as interm patch for different databases for different versions.

• Performing Schema level/Full DB Refresh using EXP, IMP, EXPDP and IMPDP.

• Performance tuning using SQLT and also by analyzing the execution plan of the query Company : TCS (TATA CONSULTANCY SERVICES)

Role : Oracle DBA

Period : November 2010 to April 2012

Environment : Oracle 10g & 11g, Linux, Windows 2003, OEM, PL/SQL, RMAN, TOAD. Team Size : 10

Responsibilities:

• Managed 9 different application of large and small databases in all the environments.

• Implemented the installation and creation of databases for production, acceptance for testing.

• Created 3 Node and 2 node RAC for the Production and Acceptance environment with ASM storage.

• Maintenance of Cluster environment in the entire RAC servers.

• Performance tuning in the critical production and development servers.

• Upgraded from 10.2.0.3 to 10.2.0.4 & 10.2.0.4 to 10.2.0.5 and 10.2.0.4 to11.2.0.1/11.2.0.2/ 11.2.0.3.

• Performed critical database tuning and optimization using tools such as Explain plan and AWR.

• Implementation of backup and recovery using RMAN, Data Protector.

• Monitoring the databases using different tools, scripts(Alerts).

• Responsible for optimizing the queries and application tuning.

• Handled the recovery of the huge ASM Production database in the critical time.

• Applied bug fixing patches and bundle patches for SAP environment using Opatch utility.

• Database refresh for the huge databases.

• Index rebuilding and index creation for the performance tuning required after analyzing the performance.

• Storage management for all the databases including the ASM storage.

• Developed the script for the backups and alerts for the database instance and scheduled in the crontab. 4

Micron Confidential

Micron Confidential

B K RAJU

Company : Karishma Software Ltd (Napier Health Care) Role : Oracle DBA

Period : March 2010 to November 2010

Environment : Oracle 11g, Linux, Windows 2003, OEM, PL/SQL, RMAN, TOAD. Team Size : 15

Responsibilities:

• Provided database administration and 24*7 support for production and development Oracle 10g databases.

• Installed and Configured Oracle RAC on Linux -- 2 node cluster with ocfs2 and ASM.

• Upgraded the databases from 9.2.0.4 to 10.2.0.3 and applied quarterly patches on a regular basis.

• Performed database tuning and optimization using tools such as TKPROF, Explain plan, STATSPACK and AWR.

• An active member of the backup and recovery team and was responsible for configuration and implementation of backup and recovery using RMAN.

• Planned and Implemented Backup and Recovery Plan Strategies.

• Handling Multiple databases like Oracle, SQL SERVER 2000 & 2005, MYSQL, IBM DB2 server.

• Database recovery for the production database due to the corruption.

• Refreshed and Cloned Development and Test Databases with Production Data whenever required.

• Developed PL/SQL stored procedures, database triggers and packages.

• Responsible for all database activities such as space management, database security management, rollback segments & creation of DB links between two oracle servers.

Company : Xerolin Integral Solutions Pvt Ltd

Role : Oracle DBA

Period : Nov 2005 to March 2010

Environment : Oracle 9i/10g, Sun Solaris 9, SQL*Loader, OEM, PL/SQL, RMAN, RAC, TOAD. Responsibilities:

• Provided database administration and 24*7 support for production and development Oracle 10g databases.

• Installed and Configured Oracle RAC on Linux -- 2 node cluster with ocfs2 and ASM.

• Responsible for installation and creation of databases for production development and user acceptance testing.

• Performed database tuning and optimization using tools such as TKPROF, Explain plan, STATSPACK and AWR.

• An active member of the backup and recovery team and was responsible for configuration and implementation of backup and recovery using RMAN and Data Guard.

• Developed PL/SQL stored procedures, database triggers and packages.

• Performed cloning using RMAN to set up development and test databases.

• Responsible for all database activities such as space management, database security management, rollback segments & creation of DB links between two oracle servers.

• Performed daily health check of the databases by implementing above backup and recovery procedures.

• Created tablespaces, tables, indexes, user logins and passwords, also provided required privileges.

• Applied Security Patches whenever necessary by downloading them from Metalink.

(B. KRISHNAM RAJU)

Contact this candidate