SUMMARY

• 10+ years of experience in the field of Database Technology with experience in designing, developing, implementing different Database’s technologies.
• Experience in AWS Designing, architecting, developing, scaling, and improving data platform and its services.
• Enabling Load Balancing in a Multi - Tier Architecture
• Import/Export and Expdp/ Impdp utilities.
• Design, architect, develop, scale, and improve data platform and its services
• Strong experience migrating applications of various technology stacks (LAMP, C++, Make, RPM, Linux, and Windows OS) from OnPrem to Cloud using a hybrid cloud infrastructure,
• Strong application development background experience including Architecting, Designing Developing, and implementing the required features.
• AWS Cloud experience in Containers (Docker, Kubernetes), DevOps other AWS services.
• Working experience with computing web services (e.g., AWS EC2, AWS S3, AWS RDS, and AWS CloudFront) directly with customers and ecosystem of system integrators and solution providers.
• Experience with monitoring and alerting using AWS services,
• Implement real time streaming, batch and near real time data movement design patterns, lead a team of engineers in best practices in ELT and data storage.
• Worked extensively in migrating on-prem oracle dbs to AWS.
• Worked on AWS DMS for Migrating Oracle databases.
• Extensive experience in Building Complex Cloud based Solutions
• Designing, implementing Processing Application Software from product designed, testing and modification, Application Architects involved in every step of the application software development process. This involves creating models and prototypes, evaluating potential risks and defects, analyzing specifications, and customizing applications for specific customers.
• Successful Application Architects generally possess strong analytical, creative, problem-solving, and critical thinking skills. I am very detail-oriented team players, and consistently provide valuable suggestions and solutions in areas of software development, and maintenance. Effective leadership skills are crucial, as Application Architects tend to lead project development teams in areas of application software design, development, testing, and implementation.
• Experience with AWS databases (RDS, Aurora and PostgreSQL)
• Experience in migration of document storage to AWS S3
• Experience of network integration and Cloud connectivity of public and private environments; Ingress and egress of data to and from AWS.
• Provide Technical leadership on application delivery for strategic projects including design, development and implementation of Applications and Business Services.
• Support database provisioning and maintenance to accomplish task objectives.
• Used TKPROF utility and Explain Plan for tuning SQL queries.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning, and documentation.

TECHNICAL SKILLS

Databases: Oracle 10g, 11g, 12c, 18c, 19c, AWS, Cloud Computing

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) PeopleSoft, Toad, OEM Grid, RMAN, SQL*Loader, SQL DML scripts, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Top, DBCA, DBUA, ADDM, Remedy, ETL

Operating Systems: UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX, Windows

PROFESSIONAL EXPERIENCE

Confidential

AWS Solutions Architect & Database Administrator

Responsibilities:

• Migrated on-prem oracle, mysql dbs to AWS cloud -EC2, RDS
• Configured New relic tool for monitoring AWS and On-Prem dbs.
• Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
• Effective leadership skills are crucial, as Application Architects tend to lead project development teams in areas of application software design, development, testing, and implementation.
• End to end application development experience both in Web App & Mobile App.
• Application development using ReactJS & Spring Boot.
• Route 53 (DNS), Cognito Authentication, Amplify console, GitHub configuration, API Gateway, Microservices, DynamoDB.
• Ability to build Docker containers and docker compose environments
• Development experience in Terraform or CloudFormation
• Understand the concepts of Governance at Scale.
• Migrated 12c oracle databases to AWS.
• Facilitate joint planning activities with stakeholders to develop a combined project schedule
• Develop and manage the project plan including the schedule of activities and deliverables/artifacts.
• Strong experience in analyzing, architecting, designing, installing, configuring, administrating, operating, monitoring, following the standards maintenance of databases.
• Ability to work in a team and individually in a complex project environmentOracle 12c with good experience in PDB/CDB Understanding of the Core Architecture\
• Linux/ Sun OS operating systems experience
• Experience with Migration, Backup & Disaster recovery
• Comfortable working with AWS CLI and knowledge of JSON and/or PowerShell scriptingExperience deploying dedicated infrastructure vs shared as well as identifying best instance type based on project requirements. Experience with java, J2EE technologies, Database, Web Services (SOAP and REST), Spring Frameworks, Spring Boot, Spring Integration, Spring Cloud Services, Microservices and Messaging architectures
• Good understanding of Azure Policy Management, Azure Monitor, Azure Backup and Recovery Services.
• Proven understanding of micro-services-oriented architecture and extensible REST APIs
• Experience designing, developing, and deploying Websites and/or Web applications, including configuration, installation, maintenance, and site-specific Web development languages and relational databases.
• Familiar with relational data concepts and database platforms like dimensional modelling, referential integrity, and platforms like MS SQL, Oracle, or Snowflake.
• Hands on experience with data engineering concepts and the associated AWS services (S3, Glue, Lambda, RDS, DMS, EMR, DynamoDB, etc.)
• Experience in CloudFormation stacks.
• Experience using Web development and graphic tools, as well as, Web Server and database administrationDesign, architect, develop, scale, and improve data platform and its servicesBuild, support and improve the continuous integration / delivery pipelines for the services and jobsImplement large-scale high-throughput solutions using on-premises and cloud technologies such as Spark on Hadoop/Hive/S3, AWS Lambda, Terraform, Kubernetes, etc.
• Diagnose and debug issues in development, staging and production environments.
• Collaborate with product/program managers, software developers and analysts in an open, creative environment. Platform Automation experience with Terraform, Ansible, ARM.
• Implement AWS Auto Scaling for monitoring Ec2 instances
• Configure Confidential Virtual Private Cloud
• Implement high level Security Groups to control an inbound and outbound traffic
• Infrastructure services such as but not limited to EC2, Route53, S3, Workspace, CloudWatch, CloudTrail, Automation deployment, RDS, Lambda, IAM & Governance, Organizations, EBS Storage & Snapshots replication, Tagging, VPCs, Security Groups, Load Balancers, VPN Gateway, Data and Server migrations, Cloud Endure, and AWS CLI.

Confidential, ASHBURN VA

AWS Solutions Architect & oracle database administrator

Responsibilities:

• Creating a user with assigning profile and privileges, revoking them as well as required.
• Performing database migration from Sun Solaris to Linux, and from Linux to Oracle Cloud Infrastructure (OCI) using traditional data pump, Golden gate for zero downtime.
• Migration oracle database on-prem linux86 64 platform to Oracle Cloud Infrastructure (OCI).
• Migrate databases from on-prem to OCI Database using Export/Import.
• Create your encrypted application tablespaces.
• Migrated EC2 instances across different AWS regions
• Install, monitor, and maintain PostgreSQL & MySQL software, implement monitoring and alerting, implement backup and recovery processes, provide system and SQL performance tuning, and assist in business process integration with various data sources.
• Ability to design high availability applications on AWS across availability zones and availability regions.
• Ability to design applications on AWS taking advantage of disaster recovery design guidelines
• Prior experience in automated build pipeline, continuous integration, and continuous deployment.Familiar with relational data concepts and database platforms like dimensional modelling, referential integrity, and platforms like MS SQL, Oracle, or Snowflake.
• Hands on experience with data engineering concepts and the associated AWS services (S3, Glue, Lambda, RDS, DMS, NoSQL Database…..
• Migrate oracle databases from on-prem to PostgreSQL platform on AWS RDS using AWS SCT and DMS task.
• Experienced in designing APIs, scale, integrate with internal and external systems and secure integrations. Experience in JavaScript/jQuery
• Exposure to cloud technology patterns (SaaS, PaaS, IaaS) on Azure
• Analyze and develop data models, logical database designs and data definitions across multiple computing environments.
• Disabling indexes during migration for zero downtime. Modifying and converting database objects from source database to the target PostgreSQL or AWS platform.
• Using log miner performing undo operations, allowing repair of logical data corruptionProvide database and systems administration support for software deployment operations, datamigration and conversion, and other critical production operations support activities as required. Experience in cloud, multi-tenant, Microservices applications using JAVA, Spring Boot, Ms Azure/AWS.
• Troubleshooting, Load Balancing, Clustering, Deploying Applications, Performance Tuning and Maintenance. Work with vendors and developers for application related issues.
• Installed the application on AWS EC2 instances and configured the storage on S3 buckets.
• Implemented and maintained the monitoring and alerting of production and corporate servers such as EC2 and storage such as S3 buckets using AWS Cloud Watch.
• Configured an AWS Virtual Private Cloud (VPC) and DatabaseSubnet Group for isolation of resources within the Confidential RDS Aurora DB cluster.
• Working with the App server DBA and Oracle DBA to resolve application problems.
• Performing Migrations of the code between test QA and production environments.
• Functions as an individual contributor and works independent of supervision to develop, design, and implement new software applications or programs and framework components of Java scriptsStrong experience using log miner to provide historical view of the database without the need of a point in time recovery.
• Coordinates and plans all the tasks required for software development and implementationPerforms gap and impact analysis of system software for change requests.

Confidential, Matawan, NJ

AWS Solutions Architect & oracle database administrator

Responsibilities:

• Worked in an environment comprising databases with the largest databases each of size 5TB.
• Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.
• Real-time change data capture (CDC) in Golden GateConfigured change data capture group for Golden GateStrong experience with change data capture (CDC) from the source database transaction logs and replication to target database.
• Using log miner performing undo operations, allowing repair of logical data corruption.
• Hands-On Experience building solutions in AWS, including services such as EC2, S3, VPC, SNS, Lambda, Dynamo DB, RDS, Redshift etc.
• Ability to create and utilize Terraform templates to automated creation of AWS images.
• Experience with DevOps tools such as Jenkins, Maven, GitLab, SonarQube in a cloud environment.
• Extensively used Data pump, conventional export/import utilities for loading data to & from databases, logical backups, and migration of databases.
• Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
• Experience of network integration and Cloud connectivity of public and private environments; Ingress and egress of data to and from AWSExperience of utilizing progressive design patterns that make use of server less technologies, dynamic scaling, event models, cost optimizations and platform services.
• Performing Migrations of the code between test QA and production environments.
• Developing the standards and tuning metrics and alert thresholds.
• Provide database and systems administration support for software deployment operations, data migration and conversion, and other critical production operations support activities as required.
• Manage Oracle/MySQL databases (Primary) and (Secondary) through multiple products lifecycle environments, from development to mission-critical production systems in both on-prem and AWS environments.
• Confidential Web Services - Create/manage/optimize - EC2/RDS instances, Cloud watch, S3 buckets, Jenkins jobs, SNS, Route 53.Assist in planning and performing database upgrades and migrationsexperience with AWS technical essentials such as RDS, EC2, S3, security, and networking.
• Ability to create and utilize Terraform templates to automated creation of AWS images
• Experience with AWS databases (RDS, Aurora and PostgreSQL)
• Experience in migration of document storage to AWS S3
• Define the high-level architecture and detailed design for the solution.
• Document the scope of the solution and high-level implementation plan.
• Identify solution dependencies and define methods to handle them though implementation of the solution.

Confidential - Marlboro, MA

Oracle Database Administrator

Responsibilities:

• Performed Installation and configuration of Oracle 10g, 11g, and 12c database on HP-UX platform.
• Worked with different middleware & IDM teams to resolve their issues from the database side.
• Experience in Replication of Data bases using Oracle Streams and Logical Standby.
• Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth, and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage. • Strong Experience with Data guard & Switchovers (Primary / Standby)
• Golden Gate - Configuring and managing replication
• Install/Configure RAC (Real Application Clusters 11g/12c)
• Transparent Data Encryption
• RMAN (Recovery Manager)
• OEM Agent Installation / Troubleshoot (OEM13c)
• Database migrations / Database Upgrades, Grid / Oracle Home / DB Patching, UNIX and shell scripting, good Knowledge, and hands on experience in Exadata.
• Strong experience using log miner to provide historical view of the database without the need of a point in time recovery.
• Performed Oracle Schema level and Table level data migrations using Data pump EXPDP/IMPDP.
• Configuring and scheduling of Oracle database backup using RMAN.
• Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
• Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Setting up of Oracle and Application user accounts and passwords, monitoring application securitySetup, ConfiguredOracleData Guard using physical standby database.
• Implemented Data guard / Standby (with FAL), performed switchover/failover.
• Worked with RAC implementation team. Added nodes.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 supports for all the production and development databases.
• Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
• Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
• Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
• Implementeddisaster recovery system, using RMANand custom written shell scripts.Create and maintainOracleData Guard configuration.

Confidential - Ann Arbor, MI

Oracle Database Administrator

Responsibilities:

• DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.2 & 5.3. Database sizes range from 4GB to 2TB (in ODS & EDW environments).
• Proven experience in troubleshooting issues related to Oracle RAC (Node Evictions, Node Reboots).
• Experienced with all facets of Oracle DBA day-to-day activities like production, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.
• Using log miner performing undo operations, allowing repair of logical data corruption.
• Real-time change data capture (CDC) in Golden GateConfigured change data capture group for Golden GateStrong experience with change data capture (CDC) from the source database transaction logs and replication to target database.
• Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/ Impdp, SQL Tuning Advisor, SQL Plan Baselines.
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
• Installed & configured Oracle Management Server (OMS) & Oracle Grid Control.
• Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
• Create database Objects, Tablespaces, Schemas as needed.
• Schema migrations from Development to Production via Tech Test environments.
• Database refresh from Production to Test as needed.
• Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10g Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.
• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfil the storage needs.
• Installed, configured, and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10gRAC servers for the purpose of disaster recovery procedures.
• Designed daily, weeklyBackup and Recovery proceduresfor production, non- production databases usingRMANbackups taking periodic Complete, cumulative, and differential Incremental Backups.
• Data Refresh/Cloningfrom Production environment to setup QA/ DEV usingRMAN Duplicate.
• Intensively used latest 10g/11gAutomatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases and used thenotificationtool to send the alerts inOEM Grid Control.
• Scheduled UNIX scripts in crontab jobs to automate daily taskslike backups, monitoring the alert logs, and backup logs to send notification emails.
• Migrated data to a new ASM Disk groupto improve the IO performance of the database.
• Export/Import, Data pump, Transportable tablespacesto migrate databases from one database to another.
• OracleDatabase monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.
• Recovery of Database(Recovering fromMedia Failure, Recovering the tables dropped accidentally, recovering data files, recovering fromBlock Corruption) from previous RMAN backups.
• Performedcapacity planning, space monitoringliketablespace growth, ASM disk space.