Database Administrator Sql Developer

Rajesh Ambadi

Database Technology Professional

** ***** ** ************ ********** in database technologies. Excellent work ethics and leadership skills.

Work Experience

Lead Database Administrator, IBM Corporation, USA

May 2014 – Present

1. Lead Database Administrator and team mentor.

2. Prioritize and coordinate all database projects and tasks.

3. Run database environments for SaaS environment

hosting Applications for development, test, production and DR environments that support Web/Cloud based

OLTP, ETL and analytics workloads.

4. Implement new NoSQL databases including CouchDB and Couchbase.

5. DB Automation using Puppet, Ansible, Terraform and Shell scripts.

6. Multi-terabyte database upgrades including Oracle 11g>12c,12c->18c,18c->19c.

7. Oracle Transparent Data Encryption (TDE) and Linux LUKS filesystem encryption.

8. SSL/TLS1.2 encryption of database connections for Postgres, Oracle, Couchbase and CouchDB. 9. Database recovery drills.

10.Multi-master replication setup for Postgres.

11.Implemented “zero-downtime” database maintenance. 12.Enforce database security and performance settings. 13.Continuous security patching across large number of diverse database systems.

14.Capacity planning, performance tuning (AWR/ASH), monitoring and dba on-call rotation.

15.Setup DB performance metrics dashboards.

16.Perform DBA reviews of all database changes.

17.Work with vendor for software bugs and issues.

18.Large database migrations to Cloud datacenters. 19.AWS technologies – MSK/Kafka/Mirror-Maker,

OpenSearch, Keyspace, RDS/Oracle

Personal Info

Location Austin

TX - 78681

Phone 215-***-****

Email *******@*****.***

LinkedIn linkedin.com/in/rajeshambadi-

3a5b4041

Education

Bachelor of Technology (IT),

University of Kerala, India.

Certifications

- Oracle 10g Certified

Professional (OCP)

- Oracle 12c Certified

Professional (OCP)

- PTE English Language

Academic

Skills

- Project management

- Troubleshooting

- Automation

- Advanced SQL and PL/SQL

expertise - Data Modeling

- DB, SQL and OS Tuning

- DB Performance tuning &

benchmarking

- High Availability setup

- Disaster Recovery setup

- JDBC connection pooling

- NoSQL

- Data strategy and stack

modernization

- DB License tracking

- Documentation

Rajesh Ambadi

Database Technology Professional

Database Administrator, Fiberlink, USA

Jun 2011 – April 2014

1. Responsible for managing the databases and

applications for SaaS environment hosting our MDM

solutions. Databases are spread across development, test and production and standby environments.

Applications include Web/Cloud based OLTP, ETL and reporting tools.

2. Automation of database administration tasks using Puppet, Ansible and Shell scripts.

3. Performed major database upgrades including upgrade from 10g to 11g.

4. Unicode/UTF8 database character set migration. The project was challenging because of non-convertible data and large database size. Lot of coordination done with Application owners to fix data issues.

5. Implemented Direct-NFS and Linux HugePage for

better database performance.

6. Setup Oracle Dataguard replication to a standby site for disaster recovery.

7. Database DR tests were regularly conducted in the form of site failover and backup restores from tape. 8. Advocated and implemented zero-downtime best

practices to reduce database outages.

9. Reviewed and enforced database best practices.

10.Routine tasks involved capacity planning, performance tuning, monitoring, database restore tests, DR tests and dba on-call rotation. Database performance was reviewed weekly, problems noted and actively worked until resolution. Various performance reports(ADDM, AWR, ASH, Segment Advisors, SQL Tuning Advisors)

were also looked into regularly to proactively catch and fix performance problems.

Technology

Oracle Database

Oracle VM Server

Linux

PostgreSQL

CouchDB

Couchbase

Kafka

Infosphere CDC

AWS RDS/MSK

Tools

Ansible

Python Bash

Puppet

Graphite

Oracle Enterprise Manager

SQL*Plus

SQL Developer

Terraform

Rajesh Ambadi

Database Technology Professional

Database Administrator, Fiberlink, India

December 2006 - May 2011

1. Responsible for setting up Production, Test and Dev environments for SaaS applications. Environments

included databases and applications. Applications used DBCP and Oracle connection pools with Oracle JDBC

thick and thin drivers.

2. Tuning application JDBC connection pools for optimal performance.

3. Database 10g upgrade in 2007. Migration was also to ASM storage, so lot of data had to be moved from old filesystem-based storage. Lots of scripting,

export/import and validation was involved.

4. Migration to faster storage on NFS with 10GigE network and Jumbo Frames with minimal downtime. Plan had

to take into account minimal downtime requirement, large data volume, performance testing, capture key metrics before and after the changes, and publish

performance improvements using key DB metrics

graphs.

5. Upgraded to new Linux servers on faster Intel/Nehalem processors with minimal downtime. Project involved significant amount of prep work for planning and

testing.

Project Engineer, Wipro, India

April 2004 – Dec 2006

1. Part of a database specialist team managing database standards for all the project groups in the BU.

2. SQL and PL/SQL code reviews to ensure compliance with the coding standards.

3. Optimize SQL, PL/SQL and database design to improve database performance.

4. Managed database instances for the group and also did data migrations.

5. Developed reusable database procedures and scripts for different projects and groups.

6. Worked as a SQL and stored procedure developer on multiple projects.

Awards

- High Impact Player

- Feather in the Cap

- Keeper of the Bell

Contact this candidate