Database Administrator Machine Learning

Prasad Injam

Present location: Clarksburg, MD Available for remote work

Email : ***********@*****.*** Clearance: Public Trust, MBI, Secret

https://www.linkedin.com/in/prasadinjam Willing to Relocate: No

Skills matrix:

Skills Years of Experince Last Used

Database Engineering 15+ Recent

AWS Engineering 5+ Recent

Terraform 3+ Recent

Summary:

A highly accomplished, results-oriented technology expert in Project Management, machine learning, 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, improves security posture and reduces technical debt.

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

• AWS Certified Solutions Architect, 2016

• 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

• 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

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

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

Professional Experience:

Booz Allen Hamilton Mclean, VA Sep 2018 – Till Date

Sr. Technology Lead/Architect

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)

• Works with direct reports and peers to develop and implement strategies and goals. Promotes innovative thinking and transparency.

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

• Built multiple DMS replications from on Premises/AWS Cloud to AWS Cloud. Upgraded Replication instances.

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

• Manage EBS Volumes, S3 Storage and customized IAM Policies giving least privileges to do the jobs.

• Created and deployed Application Load balancers using Terraform [Migration to AWS Cloud].

• Migrated on-premises infrastructure to AWS using lift and shift model.

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

• Used Golden Gate for replicating the data from on-premises to Cloud during migration.

• Adapted and used CI/CD build process for deployment code using Jenkins.

• Configured Oracle Secure Backups on EC2 instance to back up the instance to S3 using RMAN.

• Changed Backup policy to retain the RDS backups for 90 days across the region using lambda function.

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

• Improved security posture by identifying and remediating vulnerabilities in Golden Images AMI’s and converted them to global images to create redundant infrastructure across multiple regions.

• Automated image management and deployment using Terraform to streamline the provisioning process and automated using Jenkins. Most of the components on AWS echo system are build using CloudFormation and Terraform.

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

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

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

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

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

• Successfully implemented a private Git repository using Git Bucket to enhance code management and collaboration within the team.

USAF (US AirForce)

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

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

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.

• 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 May 2018 – Aug 2018

Senior Infrastructure Engineer

• 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

• Designed and developed ETL Jobs to extract data from on-premises to redshift.

• 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, DC March 2011-April 2018

Database Manager/Architect

• Led 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.

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

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

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

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

• 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 environments, 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

• Oversaw internal audit requirements and supported SOC1 for databases.

• Planned, coordinated, and orchestrated 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 orchestrated 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 (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.

Professional Development:

DF01: MongoDB Developer, MongoDB University, 2021

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

Contact this candidate