SUMMARY

• Around 14 years of IT experience as a Business Analyst and DBA (Oracle, PostgreSQL) on a variety of platforms - UNIX (Solaris, Linux, HP-UX), AWS, Azure, Windows.
• Database migration from Oracle, MySQL, and Teradata into PostgreSQL Database using SVC, DMS and Ora2pg.
• Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
• Expertise in handling database security, establishing replication between servers, Capacity Planning, Backup and Restore, shipping archival logs, Corruption and Recovery, Managing login/permissions.
• Monitoring of system performance utilizing PgAdmin and command line tools.
• Maintained custom vacuum strategies at table and db level for performance.
• Comprehensive knowledge and experience in various phases of teh Software Development Life Cycle like Requirements gathering, System Analysis, Design, Development, Integration, Testing, Deployment and Maintenance with software development models like Agile model.
• Implemented automated methods and industry best practices for daily data load (complete refresh) with halp of ETL developers.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within teh organization.
• Exposure on Azure cloud services Database Migration Service (DMS) and Ora2pg, AWS Database Migration Service (DMS).
• Good knowledge and experience in Software Development Life Cycle (SDLC) and its phases: Requirement gathering, Analysis, Design, Implementing, Testing, Deployment, and Maintenance.
• Experience in conducting GAP analysis to compare as-is with to-be business processes, SWOT analysis, Impact analysis, Cost-benefit analysis, Risk analysis.
• Experience in using business modeling tools like MS Visio and Unified Modeling Language (UML) for creating Use Case Diagrams, Business Process Models, Process Flow Diagrams, Class Diagrams, and Activity Diagrams, Sequence Diagrams, and workflow diagrams.
• Hands-on experience in Writing and executing testing scripts in SQL.
• Used various approaches of SDLC like Agile, Scrum, and Waterfall.
• Experienced in designing, developing, monitoring, and scheduling (using crontab) UNIX shell scripts to administer all teh environments.
• Database backup and recovery. Used hot and cold backups. Involved in development of scripts to automate backup and recovery procedures for development databases.
• Experience in working with high-transacted OLTP systems.
• Highly motivated, excellent team player, enthusiastic, strong initiative, and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.

TECHNICAL SKILLS

Databases: PostgreSQL 9/10/11/12, Oracle 8i/9i/10g/11g/12c, SQL Server

Oracle and other Tools: SQL*Loader, SQL*Net, OEM, TOAD, ER-studio, Oracle migration work bench, Oracle Parallel Server, Oracle Replication, OID, Data Guard, ASM, Gloden Gate, Oracle Data Integrator, RAC, OLAP, SQL backtrack and DevOps tools.

Operating Systems: Z-Linux, Sun Solaris, HP-UX, AIX4.3.3, Red Hat Linux 7.2, and Windows Server 03/08/12/16, AWS, Azure.

Languages: SQL, PL/SQL

Scripting Languages: Shell scripting, VB script, JavaScript, Perl

Markup Languages: HTML, XML (knowledge).

Web Servers: IIS, Apache, IBM

Server-side Tools: ASP, PHP

Reporting Tools: MS Project, MS-Office, MS-Visio, MSBI, Talend, Informatica, Ab Initio, oracle warehouse builder.

PROFESSIONAL EXPERIENCE

Confidential, Franklin Lakes, NJ

PostgreSQL DBA

Responsibilities:

• Database Migration from Oracle, MySQL, and SQL Server into PostgreSQL Databases.
• Maintaining and supporting PostgreSQL databases on-prem and on cloud (Azure Postgres+ both PAAS and IAAS).
• PostgreSQL Migration from on-prem to Azure cloud.
• Table Partitioning based on application requirement.
• Production support for critical databases which are of teh size 16-39TB.
• Backup/Recovery, Performance Tuning, Data loads, Connectors to other environments, SQL Tuning.
• Optimization management of Query, Storage, Index, - Data Analytics Optimization.
• Maintained custom vacuum strategies at table and db level for performance.
• Scheduled maintenance and monitoring scripts to check DB health.
• Installation of library extensions such as PgAudit, PgAudit-logtofile.
• Installation of Postgres and DB creation along with application of patches as required.
• Creating schemas, roles and users customized to each grant request.
• Advocating Vacuuming and Analyze tables to teh application users to gain DB performance.

Environment: PostgreSQL10.12/12, Azure, Oracle, MySQL, RHEL 7, Agile, Confluence, ServiceNow, Jenkins, Chef, DevOPS, PgAdmin, Shell Scripting, Dockers.

Confidential, Owing Mills, MD

PostgreSQL DBA

Responsibilities:

• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.
• Import of Reports to PostgreSQL from Oracle, Teradata, DB2 Databases.
• Table Partitioning based on application requirement.
• Administration of 9. + DB’s. Data Ingestion, Data Model optimization, Table/Index Optimization.
• Backup/Recovery, Performance Tuning, Data loads, Connectors to other environments, SQL Tuning.
• Optimization management of Query, Storage, Index, - Data Analytics Optimization.
• Maintained custom vacuum strategies at table and db level for performance.
• Configured log analyzation using pgbadger.
• Automating monitoring scripts as a proactive measure to check DB health regular bases.
• Creating roles, individual and generic users for each application.
• Vacuum and Analyze tables as per teh need of teh application.
• Planning and implementing regression testing after upgrade and release.
• Designing tables and partitions based on teh application requirement.
• Performance tuning Sqls and Databases as and when required.
• Ability to proactively identify, troubleshoot and resolve live database systems issues. Knowledge in database design including logical and physical design.
• Ability to thrive in a fast-paced, deadline-sensitive environment. Responsible for configuring, integrating, and maintaining all Development.
• QA, Staging and Production PostgreSQL databases within teh organization.
• Develop, implement, maintain policies and procedures and document database architecture to ensure teh security and integrity of teh databases.
• Implement data models, database designs, data access, table maintenance and code changes together with our development team.
• Experience in code migration, database change management through various stages of development life cycle.
• Providing response for all system / database issues on 24 x 7 Schedule responding to critical events and situations outside normal work hours.
• Work with development and operations teams to tune production queries for optimal performance.
• Implement and monitor replication for high availability and disaster recovery scenarios.
• Review new database schema changes. Monitor and manage database indexes for optimal performance.

Environment: PostgreSQL9/10, AWS RDS / Aurora, DBeaver, Teradata, MongoDB 3.4/3.6, AIX, RHEL 7, Agile, Confluence, ServiceNow, DevOPS, Jenkins, Chef, Shell Scripting.

Confidential, San Francisco, CA

PostgreSQL DBA

Responsibilities:

• Contracted to provide expert judgment, establish integrated change control processes and to direct and upgrade almost 45 databases and related projects, software and security updates, regulatory compliance and state mandated code changes, application enhancements, data quality audits, data extracts and modernization projects.
• Configuring and fixing teh Issues with Pgadmin-III client application. Responsible for monitoring environments using monitoring tool viz. Nagios.
• Installing and configuring new servers as per customer's request. Cloning teh Development, test and UAT environments with production data as per customer's request.
• Migrating databases from Oracle to Postgres.
• Develop and enhance scripts to automate and execute various DBA tasks.
• Co-ordinated with all application owners who use teh databases to pursue teh upgrade project.
• Developed a highly secure database user's environment by implementing tight profiles, roles and managing database sessions.
• Automated Upgrades and patches using Jenkins and Chef configuration management.
• Constant monitoring of database space and space management
• Responsible to improve teh performance by Using teh Hints, Indexes, Explain Plan.
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Designed teh regression testing for each database with all jobs and performance respectively.

Environment: Oracle 12C/11g, PostgreSQL, DB2 Mainframe Z/Os, AWS, Ora2pg, PgAdmin, ASM, RHEL 7, Jenkins, Chef, Shell Scripting.

Confidential, Teh Woodlands, TX

Database Administrator

Responsibilities:

• Responsible for Database Administration for day-to-day operational support of PostgreSQL, and Versant databases as well.
• Ensuring that database backups of different environments are being taken successfully.
• Designed and Implemented Sharing and Indexing Strategies for MongoDB servers.
• Extensively worked with Mongodump, Mongoexport/import, Mongostat, Mongotop, MMS tools.
• Designed MongoDB replica sets and multi-sharded cluster. Experienced in upgrading 3.2.x databases to 3.4.x.
• Designed and developed load balancing Mongo applications.
• Set up and configured MongoDB Cloud/Ops Manager for monitoring and backup/recovery.
• Experience in SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.
• Exposure on AWS Database Migration Service (DMS).
• Scheduling jobs and troubleshooting in case of failure.
• Performing restores and data refreshes as per teh requirement using impdp/expdp and sqlplus.
• Run scripts to create database objects and data manipulation as required.
• Responsible for performance upgrades to newer DBMS versions or preparing upgrades to newer DBMS versions or preparing an application to upgrade itself.
• Wrote monitoring scripts for Gloden gate, general maintenance scripts for daily automation tasks.
• Troubleshooting, Performance Tuning Gloden Gate issues
• Documented Design and change management for all process.
• Manage sharing of resources amongst applications.
• Primary DBA for 84 databases and responsible for all quarterly refreshes, upgrades, patches, monitoring and administration.
• Database and schema refreshes using impdp/expdp, imp.exp, Cold clone and RMAN duplicate very often.
• Performance tuning including database and SQL tuning to improve performance using tools like AWR, ASH, Explain Plan and theirby gathering stats, creating indexes, hints and altering parameters whenever required.
• Assisted in logical and physical database design.
• Installed, upgraded, and patched Oracle software and associated applications.
• Wrote PL/SQL procedures, triggers, and functions to enable plug and play of multiple data sources.
• Trained a new DBA in our environment.
• Participating in on call rotations supporting more TEMPthan 2500 oracle and versant databases.

Environment: Oracle 12C/11g/10g/9i, PostgreSQL, PgAdmin, OID, OEM 12C, ASM, SVN, GlodenGate, DataGuard, MongoDB 3.2/3.4, Hadoop, AWS, Windows Server, AIX, Linux, HP-UX, PL/SQL, RMAN, Azure, Versant 6.4/5/6, SQL Server, SAP, Upstream, Downstream, TOAD, SQL Loader, Shell Scripting.

Confidential, Dallas, TX

Project Manager/Business Analyst

Responsibilities:

• Spearheaded project planning, requirements gathering, resource allocation, budget and expense analysis, gap analysis, status reporting, and implementing end-to-end product lifecycle under Agile Methodology.
• Created Business Requirements Documents (BRD) and Functional Requirements Specifications (FRS) documents
• Facilitated and led JAD sessions, GAP analysis, SWOT analysis, risk analysis to document business requirements, providing strategic recommendations and sharing best practices to ensure teh proposed solutions.
• Facilitated teh adoption, implementation, and sustainability of agile processes, principles, and practices.
• Managed both functional and non-functional Business Requirements as well as new requested requirements using Confluence.
• Steered teh acquisition platform that enables customers’ new application journey for Credit Instruments
• Gatheird feature objectives from Business Owners and stakeholders (Risk, Marketing) in close collaboration with Technology SMEs/Architects.
• Gatheird, interpreted, and documented user requirements and translated them into Analytical User Stories and personas using UML techniques and Tableau dashboards.
• Incorporated Automated Clearing House (ACH) functionality for teh Private Label Credit Cards for Cash Advance abilities.
• Worked as a point of contact with First Data (Visa/MC/Discover) and AMEX for Payment certification and specification of teh payment process for dis application of Wells Fargo.
• Participated in vendor relationship management, vendor selection, RFI/RFP process, SOW.
• Integrated and tested EMV with payment providers like ACI, Eigen, Merchant Link, and Verifone.
• Defined and created new user experiences that enable Wallet provisioning experience of teh approved credit card like adding an approved card to Apple Pay.
• Provided hands-on team guidance, support, and coaching in close cooperation and collaboration across all roles and functions, to facilitate increasing maturity at a sustainable pace.
• Coached specific areas including Sprint events and activities: planning, daily scrum, refinement, reviews, and retrospectives.
• Provided training to Scrum Masters, Product Owners, and Teams through workshops and individually.

Confidential, Lansdale, PA

Business Analyst

Responsibilities:

• Gatheird and documented high-level functional and non-functional business requirements from stakeholders by implementing different elicitation techniques under Agile SDLC methodology.
• Utilized MS SharePoint server to document requirements for customer-specific invoicing and other documents such as test results.
• Clarified business requirements, experienced in performing Gap Analysis, Impact Analysis, Risk Analysis, Traceability Matrices, SWOT Analysis, and Cost-Benefit Analysis.
• Acted as Joint Application Development (JAD) facilitator and meetings coordinator with excellent interpersonal skills.
• Created relationships in Requirement Traceability Matrix (RTM) linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Handled scrum team, daily Scrum Meeting, Planning, Scope, daily Status Tracking, Coordination, Problem-solving, Defect Triaging, Sprint Grooming, and Retrospective Meeting.
• Involved in Inception Phase and prepared vision statements and initial data models that contain Business Requirement Documents and supporting documents that contain teh essential business elements and detailed definitions.