Ankit Asthana

Work Authorization: Green Card

Email: ad3xws@r.postjobfree.com

Cell: 443-***-****

Leveraged extensive 20+ years of technology industry experience to provide strategic guidance and drive innovation in Database technology solutions with increased system performance, scalability, and security across organizational platforms. Led and successfully delivered high-priority, corporate-driven technology projects, including database encryption (TLS), business resiliency, migration to AWS and VMWare cloud, storage cost optimization, and sustainability initiatives, driving significant cost savings and enhancing operational efficiency. Orchestrated seamless collaboration between outsourcing teams, internal higher management, product vendors, enterprise architects, and cross-functional teams to drive successful project execution and achieve increase in customer satisfaction ratings through improved communication channels and streamlined processes. Implemented robust technical project management methodologies with reduction in project delivery timelines and an increase in on-time project completions. Spearheaded team growth and development through knowledge sharing and mentorship, fostering a collaborative environment that resulted in an increase in employee satisfaction by leadership and team management.

Highlights

• Oracle Certified DBA + AWS Solutions Architect with expertise in Analytic databases, Document DB, along with BigData Hadoop admin (Hortonworks) experience

• Oracle expertise in Database Architecture, Engineer, Administration, Automation, Design, Migration, High Availability, Sustainability, Development, Maintenance, Support and Implementation as development and production DBA on Oracle

(19c/12c/11g/10g/9i) databases (OLTP/DWH) in UNIX & Windows environments

• Lead & managed Vertica (9.x & 11.1.x), Actian Matrix (Paraccel), Snowflake platform including Architecture, Installation, Configuration, Automation, Administration, Design, Replication, Sustainability, Maintenance and Support

• Lead transformations from Matrix to Vertica database platform migration, from On-Prem to VMWare Cloud, On-Prem to AWS Cloud RDS, Vertica to Snowflake

• Exposure to Amazon Web Services like RDS PostgreSQL, Redshift, Lamda, CFT (Cloud Formation Templates), EC2, S3 Bucket, Glacier, Cloud Watch, managing security groups, VPC, Route53

• Expertise in Performance tuning & Troubleshooting of Applications & databases

• Enthusiastic about Database architecting, designing, planning with integrated infrastructure security features

• Implemented design automation processes that streamlined product development lifecycle, with a reduction in design iteration time and increased on-time deliverables

• Spearheaded cross-functional collaboration to design and implement a scalable database architecture, resulting in reduction in data retrieval time and improved system performance

• Understanding of Data Lake, Data Science, Data Pipeline, Data Cleansing, Data Ingestion (Batch / Streaming), Data transformation, Data migration, Data Analytics, Data Scientist (Analyst + Architect + Engineer + BI), Big Data

• Exposure to Mortgage, Hospitality, Telecom, Financial, Pharmaceutical, Insurance industries Technical Exposure

• On-Prem Oracle databases with clustering (RAC & Exadata), High Availability (using Dataguard and observer), Encryption, Performance Tunning, Scalability, Sustainability, Business Resiliency & Security

• On-Prem Analytic Databases (Columnar) - Actian Matrix (Paraccel), Microfocus Vertica, IBM Netezza

• BigData administration with Hortonworks (Hadoop)

• Cloud RDBMS - AWS RDS PostgreSQL, AWS Redshift, Snowflake

• On-prem (Row Based) – Oracle, IBM DB2, MSSQL, SAP Sybase, PostgreSQL

• NoSQL - MongoDB

• Automation using Shell script, Python, Ansible playbooks, Splunk, Bladelogic

• Integrated tools like Vormetric, Guardium, Weblogic, SOA, Tableau, Nessus Tennable, ADDM, DDM, Foglight, Data Domain Boost, Cyberark, Hashicorp, Keychain

Education

• Master of Computer Applications (MCA)

• Bachelor in Mathematics

PROFESSIONAL EXPERIENCE Freddie Mac June 2014 – Present

Engineering Tech Lead Mclean, Virginia

Environment: Oracle (Cluster & Standalone) 19c/12c/11g/10g, AWS Redshift, AWS PostgreSQL, Vertica, Snowflake, DB2, Sybase, Mongo, PostgreSQL, Hortonworks Hadoop

Skills: Leadership · Team Management · Product Management · Cross-functional Collaborations · Automation · Technical Project Management · Database Security · AWS Relational Database Service (RDS) · Business Resilience · Oracle Database Administration · Database Architecture · Database Design Experience:

• Acted as the interim manager for a team of 30+, providing guidance, mentorship, and performance feedback; achieved an increase in team morale and productivity during the transition period.

• Achieved numerous standing ovation awards from stakeholders & partners.

• SME of Oracle, Vertica, Matrix, Snowflake database platforms with wide exposure to Compliance (Data-at-rest & TLS Encryption), Vulnerabilities (PKI, Java, Log4J, Patch), Sustainability, Database Security, Inventory Management, Baseline Security (BSc), Account Vaulting (Cyberark & Hashicorp).

• Architected & Designed Business Resiliency, Database Encryption, Sustainability, CA certificate management, Build & Retirement procedure, Database Monitoring & incident management using Automation.

• Created and maintained detailed project schedules, tracking milestones and dependencies with a robust issue tracking system, facilitating prompt identification and resolution of project issues.

• Expert in Architecting & Designing Database encryption using CA certificates + strong ciphers.

• Streamlined complex infrastructure & corporate driven projects as the technical lead & technical project manager with excellent customer feedback.

• Facilitated the new infrastructure for Datawarehouse, Peoplesoft, SOA/OSB, Oracle IDM (Identity Management) applications.

• Extensively researched on performance tuning by performing on-going assessment of database performance and identification of problem areas using AWR (Global), ADDM, ASH, Oracle Cloud Control, tkprof, SQL code and scripts.

• Performed database capacity planning related to database growth and system utilization, trend analysis and predicting future database resource requirements.

• Expertise in RAC to RAC Dataguard with observer for high availability solution.

• Extensively operated on Failover/Switchover scenarios using Dataguard/Observer. Fannie Mae June 2013 – June 2014

Senior Database Administrator Reston, Virginia

Environment: Oracle 12c/11g/10g, RAC, ASM, Dataguard, Oracle 11g Grid control, Veritas Cluster, IBM Netezza, Linux, Solaris, AIX

Skills: Oracle Database Administration · Database Architect · Analytical Skills · Database Design · Performance Tuning Experience:

• Provide technical expertise in database area throughout the life cycle of the projects such as preparing database objects, refresh databases from production to lower environment, migrate database objects from one environment to the other.

• Applied SECURITY PATCHES and INTERIM (one offs) patches across all the environments.

• Design and create database schema scripts (DDL), deploy schema build scripts, maintain database baselines, support application requirements, testing and implementations.

• Facilitated development teams for moving changes to different development, test levels and prepared documentations to move changes to the live production environment.

• Tune, optimize and monitor the database clusters and instances to achieve optimal performance in meeting defined SLAs

(Service Level Agreements)

• Analyze, resolve and recommend solutions to highly complex technical problems such as performance issues, integration of object-oriented relational database technology, data quality issues.

• Extensive experience in Cloning & duplicating cross platform databases using RMAN.

• Installed Oracle 11g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related issues and configured with Application Servers in Development and Production environment.

• Developed & delivered briefings, technical presentations, & program documentation to senior program management

• Maintain database operation environment with SOX compliance and adhere to corporate policy Freddie Mac December 2011 – May 2013

Senior Database Administrator Reston, Virginia

Environment: Oracle 11g/10g/9i, RAC, ASM, Dataguard (Active, Physical, Logical), Oracle 12c cloud control / Grid Control, Linux, Solaris, AIX

Skills: Oracle Database Administration · Leadership · Technical Project Management · Analytical Skills · Database Design Fannie Mae April 2010 – November 2011

Senior Database Administrator Herndon, Virginia

Environment: Oracle 11g/10g EE, Logical Dataguard, Grid Control, TOAD, WinCVS, ERStudio, Linux, Solaris The Hartford May 2009 – February 2010

Oracle Systems DBA Hartford, Connecticut

Environment: Oracle 11g Enterprise Edition, RAC, Active Dataguard, Grid Control, EXADATA, Linux, Solaris AT&T July 2008 – May 2009

Database Engineer Annapolis, Maryland

Environment: Oracle 11g/10g/9i, PL/SQL, MYSQL, SQL Server 2000/2005, ERWin, Shell Script, TOAD, Red Hat Linux, HP-UX, AIX, Solaris, Windows.

TIAA-CREF February 2007 – April 2008

Oracle DBA Newyork, Newyork

Environment: Oracle 10g Enterprise Edition Suite, PL/SQL, Oracle Warehouse Builder, Oracle Heterogeneous Services, SQL Server 2005, ERWin, MYSQL, HP-UX, Window 2003, Shell Script, PL/SQL Developer, SQL Developer, TOAD 8.5 Drugstore.com July 2006 – January 2007

Oracle DBA/Developer Bellevue, Washington

Environment: Oracle 8i/9i/10g, Reverse Engineering, Shell Script, Tru64, Linux, Solaris. LeMeredian Hotels & Resorts April 2004 – June 2006 Oracle DBA London, UK

Environment: Oracle 8i/9i Enterprise Edition, Oracle Application Server 4.0.8/9i, Oracle Forms 6i/9i, Shell Script, TOAD, VB 6.0, C, Windows, HP-UX

Tata TeleServices Limited February 2003 – March 2004 Oracle Developer / DBA Gujarat, India

Environment: Oracle8i Enterprise Edition, PL/SQL, VB 6.0, PL/SQL Developer, TOAD

Contact this candidate