Resume

Sign in

Database Management

Location:
Germantown, Maryland, United States
Posted:
August 11, 2018

Contact this candidate

Resume:

Prasad Injam

***** ******* ***** ***** **********, Maryland 20871 240-***-**** ac6mu9@r.postjobfree.com

Summary

A highly accomplished and results-oriented Senior Infrastructure Architect with an extensive record of experience in database administration, cloud solutions architecture, system infrastructure, network configuration, backup and recovery strategy, storage management, capacity panning, database migration, performance tuning, and managed services. Leverages excellent team leadership, mentoring, communication, and collaboration skills. An adaptable problem solver who improves operational processes to enhance productivity and efficiency of mission-critical systems

Experience

CACI, Annapolis Junction

Senior Infrastructure Administrator, 2018 – Current

Working on MIDAS which is part of CMS.

Currently supporting migration of Oracle Databases to AWS.

Building Redshift Cluster; Planning and coordinating all activities for the migration.

ICMA-RC, Washington, District of Columbia

Infrastructure Team Lead for Database Administration, 2008-2018

Set up databases in AWS using RDS and connected the database to EC2 instance for contingency applications.

Managed “Infrastructure with Code” where all new deployments were built with new infrastructure using Ansible scripts to automate the deployment process.

Managed implementation of 12c multi-tenant in all environments.

Secured operation of Oracle databases on Exadata Machine (Linux) and Microsoft SQL Server databases in Windows environment.

Responsible for database upgrades, backup and restore; Perform server performance tuning

Perform optimization and tuning of data loads and extractions

Perform server and storage capacity management and planning for the most complex and critical systems

Recommend and implement process and tool improvements to improve the efficiency and effectiveness of the organization's change management and configuration management processes and systems

Managed Migration from Oracle to Postgresql in Amazon. Planned and Coordinated with vendors to Outsource MySQL database.

Oversaw internal audit requirements and supported SOC1 for databases.

Planned, coordinated, and managed disaster recovery exercises using Data Guard technology.

Leveraged strong domain knowledge on Oracle switchover and failover technologies, designed and implemented always on availability group on SQL Server.

Supported SAS implementation into AWS Cloud and managed automation process.

Ensured exceptional client relations and vendor management.

Migrated Exadata from X3 to X5 and installed OEM13c on Linux VM Machine.

Worked on solutions to move elements of infrastructure to cloud and implemented dual authentication across all devices.

Coordinated AWD imaging system upgrade and moved all read-only users from production primary to active standby database.

Implemented CIS security standards in all production environments and met tripwire requirements, data redaction, data encryption on network, and TDE.

Implemented HCC (hybrid column compression).

Coordinated with Oracle Platinum team every quarter on scheduling and conducting patch work, meeting Exacheck requirements.

Upgraded all databases to 12c and migrated from Solaris 10 to Exadata Machine x3 in 2013 and X3 to X5 in 2016.

Planned and coordinated all data refresh activities across organization.

Mentored other team members, monitored nightly loads, and enhanced scripts.

Applied quarterly patches on all instances across environments.

Upgraded RAC cluster from 10.2.0.3 to 11.2.0.1 in multiple phases in all environments.

Analyzed and implemented SSN conversion project.

Finished upgrading grid infrastructure from 11.2.0.1 to 11.2.0.3 across multiple environments.

Worked with infrastructure team to upgrade multiple COTS applications.

Documented and managed recovery scenarios, startup and shutdown procedures, and DBA team support policy and procedures.

Planned and coordinated all database activities with application managers.

Additional Experience

NATIONAL PUBLIC RADIO (NPR), Washington, District of Columbia, Database Administrator, 2005-2008. Upgraded production database (RAC) from 10.1.0.3 to 10.1.0.5. Created custom TAF services. Built Oracle RAC on 10.2.0.3 for staging environment (Sun Solaris). Moved some business processes from trigger to Oracle Advance Queuing to enhance application performance. Used AWR Reports for performance tuning. Maintained Oracle 10g RAC Clustered Database for mission-critical production system, using ASM on multiple disk groups. Developed UNIX shell scripts (Ksh) and pl/sql procedures for automating batch jobs using Oracle Scheduler.

THOMSON FINANCIALS, Rockville, Maryland, Oracle Database Administrator and Database Engineer, 2003-2005. Developed, delivered, and maintained financial application for Wachovia Securities Inc. Identified functional gaps and implemented data conversion to merge Prudential data with Wachovia and provided 24/7 database production support.

APPLIED CREATIVE TECHNOLOGIES, Germantown, Maryland, Oracle Database Administrator, 2002-2003. Used ACTrax, a scalable manufacturers’ warehouse management system (m-WMS) designed to track products in a plant, including raw materials, work in process, and finished products. It provided real-time access to inventory, receiving, quality and shipping information. It is a 3-tier distributed application.

MIAMI DADE POLICE DEPARTMENT (MDPD), Miami, Florida, Database Administrator, 2000-2001. Implemented PETS (Property and Evidence Tracking System) that supported the MDPD Property and Crime Laboratory Sections with a vast variety of modules in an Oracle8.x, HP-UNIX, Windows NT environment.

STATE HIGHWAY ADMINISTRATION, Baltimore, Maryland, Programmer, Database Analyst, 1998-2000. Oversaw design, development, and implementation of State Highway Administration Project Management System application using JAD (Joint Application Development) Sessions involving system developers, key knowledge resources, and users collectively working through issues. Validated data received from various sources.

CONTINENTAL COFFEE LIMITED, Hyderabad, India, Programmer, Analyst, 1993-1998. Oversaw planning, installation, and management of corporate information systems infrastructure instrumental in creating MIS for human resources, accounting, purchasing, manufacturing, and production departments.

Education

UNIVERSITY OF MARYLAND UNIVERSITY COLLEGE, Adelphi, Maryland

M.S., Information Technology, 2008

OSMANIA UNIVERSITY, India

Master of Accounting and Finance, 1995

Bachelor of Commerce, 1993

Certifications

TOGAF 9 Foundation, 2018

AWS Architect Professional, 2017

ITILv3 Foundations, 2017

AWS Certified Solutions Architect, 2016

OCP (Oracle Certified Professional, Oracle 12g), 2015

Oracle Exadata 11g Certified Implementation Specialist, 2013

Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure Administration, 2012

OCP (Oracle Certified Professional, Oracle 11g), 2009

Real Application Clusters for Administrator Certified Expert, Oracle Database 10g R2, 2008

OCP (Oracle Certified Professional, Oracle 10g), 2005

OCP (Oracle Certified Professional, Oracle 9i), 2003

Skills Matrix

Databases Oracle, SQL Server 2008/2012/2016, Postgresql 10, Oracle Exadata, RDS, MySQL

Languages SQL, PL/SQL, Ansible, T-SQL, JSON, Unix Shell Scripting

Technologies Data Guard, Golden Gate

Cloud Technologies AWS – RDS, EC2,, RedShift, Redshift Spectrum

Utilities TOAD, SQL Developer, SQL Server Management Studio

Tools Remedy, ServiceNow, CA Scheduler, CommVault (for Backup & Restores)

Operating Systems Linux, Solaris, Windows

LANGUAGES

English (Fluent)

Hindi

Telugu



Contact this candidate