Database Administrator Project Management

Prasad Injam Residence: Clarksburg, Maryland

Cell 240-***-**** Willing to Relocate: No

Email : ad5y46@r.postjobfree.com

https://www.linkedin.com/in/prasadinjam Prasad Injam

Summary

A highly accomplished, results-oriented technology expert in Project Management, machine learning, database administration, cloud solutions architecture, system infrastructure, network configuration, backup and recovery strategy, storage management, capacity planning, database migration, performance tuning, and managed services. An adaptable problem solver who improves operational processes to enhance productivity, efficiency of mission-critical systems, improve security posture and reduce technical debt.

COMPETENCIES

· Database Architect and Administration (23 yrs.) · Program/Project Management Support (15+ yrs.)

· Oracle Database Administration (23 yrs.) · MySQL and Postgres Database Administration (2 yrs.)

· Cyber and Compliance Support (7 yrs.) · Agile Development (3 yrs.)

· AWS Cloud Technologies (4 yrs.) · Operations and Management (20+ yrs.)

· Oracle Exadata Appliances (11 yrs.) · Python (2 yr.), pySpark

· Oracle RAC Administration (13 yrs.) · Data Science (2+ yrs.)

Skills Matrix

Databases Oracle, PostgreSQL, Oracle Exadata, RDS, MySQL, AWS Aurora, DynamoDB

Languages SQL, PL/SQL, Ansible, JSON, Unix Shell Scripting, AWS SDK Python (boto3)

Technologies Data Guard, Golden Gate, AWS CLI

Cloud Technologies AWS – RDS, EC2, RedShift

Utilities TOAD, SQL Developer, pgAdmin, SQL Workbench

Tools Remedy, ServiceNow, CA Scheduler

Operating Systems Linux, Solaris, Windows

Experience

Booz Allen Hamilton, Mclean, VA

Sr. Technology Lead/Architect, Sep 2018 – Till Date

Collaborated with key stakeholders and internal teams to define enterprise architecture principles, standards and guidelines, and blueprints. Experienced Production Operations specialist with a demonstrated history of working in Managing Databases on Premises and cloud. Skilled in Process Improvement, Data Analysis, Agile Methodologies, and Team Building with a Master of Information Technology (MSIT). Worked on several technical Proposals with the Project Team, supporting multiple federal clients. Support the business development lifecycle (Business Development, Capture, Solution Architect, Pricing and Proposal Development).

VA (Veterans Affairs)

Managing and mentoring Database Engineering Team to build high Performing Team. Works with direct reports and peers to develop and implement strategies and goals. Promotes innovative thinking and transparency.

Used mlFlow to register the models for comparison. Developed and implemented predictive modelling using Random Forest and Nural networks.

Write SOP and publish in Confluence. Collaborating with Agile Team on the JIRA tickets to improve team velocity.

Build strategic planning for Standardizing the RDS databases across the board. Upgraded and Patching RDS databases to 19c using Cloud Formation, Managing KPI’s

Operating as trusted advisor and influence key stakeholders across the enterprise. Work with team members to deliver project requirements, develop solutions within the team for AWS Gov cloud.

Building Data Pipelines using PySpark, building apps using Plotly Dash.

Built Docker Images (podman) to deploy lambda functions with python for loading xml data from external sources. Designed microservices using Flash on Docker Image

Built multiple DMS replications from on Premises/AWS Cloud to AWS Cloud

Used AWS Lambda with python to manage databases and monitoring for multiple AWS Accounts. Used AWS Event Bridge to monitor oracle alerts.

Built a home-grown Data Masking Technique and Process to migrate the data from Prod to non-prod using

python. Presented the idea to broad audience and implemented within AWS echo system.

Supporting Tableau Server and user management. Facilitating Developers on building dashboards.

Managing the client expectations for data replication using Golden Gate 12c on Replication hub model.

Creating and Managing Multi-AZ Oracle RDS instances with Read Replica. Managing Repository with Architecture Diagrams and standardizing the process enterprise-wide.

Working with Cyber Team on FISMA requirements.

Automating AWS Infrastructure with CloudFormation and Terraform to manage Infrastructure as code.

Led development and delivered a comprehensive migration process to Migrate Multiple legacy Databases from on-premises to AWS RDS. Build a Disaster Recovery Plan for the complete infrastructure using terraform and cloud formation.

Upgraded multiple databases from 11g/12c to 19c on AIX.

Built ansible scripts with python for Oracle Patching using oraPatch module. Building New Infrastructure (EC2) and installing all required software and Application releases.

Managing current Ansible playbooks using Ansible Tower.

Upgraded Cloud Control 13c from Release 3 to Release 4 on EC2 instance.

Automated most of the database monitoring activities for RDS instances using aws lambda and bash scripts.

Build Data Migration plan from SalesForce to AWS RDS using AWS native tools.

IRS (Internal Review Service)

Using Cloud Control 13c – to Applied Oracle Quarterly patches in 4 environments; database hardening.

Designed and Deployed data security model for IRS using Virtual Private Database. POAM review

Built the Database Infrastructure for TDC-ON, Tax Pro Applications; Standby Database using Oracle Restart 18c. Hardening database as per cyber requirements. Supporting webapps.

Automated the process to capture all critical operational information on the database server for daily reporting for all environments.

Adapted and used CI/CD build process for deployment code using shell scripting.

Using ServiceNow for Tracking Tickets and Dashboards to meet customer SLA’s. Wrote Agile Stories; Acceptance Criteria in CLM.

DOL (Department of Labor)

Worked on AWS Glue to manage ETL Jobs and H2B - Randomization Process for DOL

Wrote AWS Lambda function to create a scheduled snapshot for RDS database as per audit requirements.

Used RDS snapshots to data lakes exports to S3; Designed AWS reference architecture.

Currently involved in Designing an ETL process to build a data lake for a federal client. Used Athena to process structured/un-structured data sets.

Build data pipelines for GitLabs

Used AWS SDK python scripts to manage Startup/Shutdown Procedures and EC2 instances.

Built AWS architecture for building Data Lakes and Coordinating with multiple agencies.

Managed Oracle, PostgreSQL and MySQL Databases at GSA.

CMS, Annapolis Junction

Senior Infrastructure Administrator, May 2018 – Aug 2018

Supported the MIDAS project for CMS to support the migration of Oracle Databases to AWS, manage workload and resizing Cluster, build Redshift Clusters, plan migration activities, and administer MySQL and Postgres databases

Worked with the developers on designing the tables, distribution styles and monitoring query performance

Built the dynamic scripts to Migrate databases from datacenter to cloud.

ICMA-RC, Washington, District of Columbia

Database Manager, March 2011-April 2018

Managed database team and overall planning/implementation of database technologies.

Oversaw strategic planning for team, orchestrated day-to-day operations, met requirements of information security, incorporated industry best practices, introduced appropriate tools and systems, and proactively engaged with customers and colleagues to drive outcomes.

Supervised full-time and temporary staff, managed PostgreSQL, Microsoft SQL Server and Oracle database environment, worked effectively across organizational boundaries, mentored junior staff, and incorporated new technologies as appropriate.

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

Built ansible Playbooks to deploy disposable infrastructure for every release. Created inventory in Ansible for automating the continuous deployment and written playbooks using YAML scripting

Customized configuration settings of to build WAR files and further developed and integrated Ansible Playbooks to pull the Artifacts stored in git to continuously deploy the archives on to WebLogic Application Servers.

Created custom dashboard to monitor Redshift Cluster. Managing workload using amazon redshift.

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

Carried out operational and performance reviews of team members to drive effectiveness.

Orchestrated implementation of 12c multi-tenant in all environments with TDE.

Secured operation of Oracle databases on Exadata Machine (Linux). Monitoring for 24x7 Production environment, resolution of server performance and user access issues.

Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department

Managed Migration from Oracle to PostgreSQL in Amazon. Managed vendors to Outsource MySQL database.

Oversaw internal audit requirements and supported SOC1 for databases.

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

Transitioned SQL database team from infrastructure to DBA team. Involved in Enterprise Architecture Review board.

Ensured exceptional client relations and vendor management.

Help compress large volume partition table/archive data by using Oracle HCC (Hybrid Columnar Compression) techniques. Resource management using DBRM and constant measuring of Exadata Performance Metrics. Configured DBFS

Migrated Exadata from X3 to X5 and installed OEM13c on Linux VM Machine. Created OEDA requirement document for oracle to setup new Exadata X5 machines.

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

Kept senior management informed in biweekly status/project reports

Primary technical resources in SQL tuning in Exadata Production using statistics, Query re-writes, SQL tuning set etc.,

Key member with domain knowledge and makes critical decisions with other stack holders that impact overall project implementations.

Senior Database Administrator, June 2008- Feb 2011

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).

Upgraded all databases to 12c and migrated from Solaris 10 to Exadata Machine x3.

Planned and coordinated all data refresh activities across organization. Applied quarterly patches on all instances across environments.

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

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 orchestracted recovery scenarios, startup and shutdown procedures, and DBA team support policy and procedures.

Installed and configured High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments with Active/Active configuration;

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

AWS Architect Professional, Specialty, 2017, 2020, re-Certified 2024

Databricks Certified Data Engineer Associate, 2024

AWS Certified Database - Specialty (DBS), 2020, re-Certified 2023

AWS Certified Data Analytics – Specialty, 2023

AWS Certified Machine Learning– Specialty, 2020, re-Certified 2023

CompTIA Security++, 2023

Tableau Desktop Specialist, 2022

Terraform Associate, 2021

EDB Postgres 12 Associate, 2021

AWS Security Certified – Specialty, 2020,

PMP, TOGAF, PMI-ACP, ITILv3 Foundations

OCP (Oracle Certified Professional) Oracle 9i, 10g,11g, 12c

AWS Certified Solutions Architect, 2016

OCE (Oracle Exadata Implementation Specialist), 2013

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

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

Professional Development

DF01: MongoDB Developer, MongoDB University, 2021

Helping Individuals Lead Successfully (HILS), STAUB Leadership International, 2018

LANGUAGES

English (Fluent), Hindi, Telugu

Contact this candidate