SUMMARY:

A graduate in Electronics Engineering /Computer Sc., working in the field of information technology for over 19+ years in various capacities of software engineering including management roles. Specialized in PostgreSQL / Couchbase / Oracle database administration, Infrastructure management and Engineering. Has strong background of enterprise database architecture, design, data modeling, high availability configuration, performance tuning, backup and recovery using RMAN, data pumps, replications (materialized views), korn shell scripting, High Availability solution using Oracle Data Guard and Oracle RAC ( 8 nodes), Database Security Implementation (STIGS), Installation of oracle database software, quarterly PSU (CPU patches), Upgrade / Migration of databases and capacity planning in large mission critical production and development environments. The projects include Data Warehousing, Data Mart, OLTP, DSS, MRP - II (ERP), CRM, HR, Payrolls, Financial Accounting Systems, Electronic Publishing System, Health Record Systems and many other applications. In addition, worked on configuration and installation of BigData / Confidential (Hortonworks), R, RHadoop, NoSQL ( Confidential, Couchbase 2.5.1, 2.5.2, 3.0.3), and Amazon AWS (EC2, SNS, S3, EBS, AMI) environments, RHEL 7, UBUNTU and Windows.

TECHNICAL SKILLS:Databases:

• PostgreSQL 9.5.4
• EnterpriseDB (Postgres Plus Advanced Server)
• Couchbase 2.5.1. 2.5.2, 3.0.3, 4.5.1
• Neo4j
• Confidential 2.6, 3.0
• MySQL
• SQL Server
• Oracle 10.2.04(10g), 11.1.0.7/11.2.0.3 (11g), 12.1.0.1(12c),

• Linux (Ubuntu, CentOS, Red Hat AS 2.1 / RHEL/6/7)
• HP-UX 10.2.03/11
• IBM AIX, Sun OS (5.10)
• Sun Solaris (7/8/9/10)
• Windows (2000/2008//XP/7/8)

• SQL and PL/SQL
• Unix / Linux (Korn Shell,awk,sed)
• Couchbase N1QL(cbq),
• Mongo Shell
• R (Rstudio)
• Pig, Hive (Familiar)

Other Software / Tools: Git / Github / GitLabs, RStudio, JIRA, TFS, Vormetric Data Encryption, Oracle Enterprise Manager (OEM)/ Grid Control, DataGuard 10g (HA), Oracle RAC, RMAN, Oracle AS 10g, WebLogicServer, VMWare VSphere 5, VMWare workstation / player, Veritas Indepth, Q-Centrl for Oracle (Quest), CommVault Simpana, Net App, ERStudio 5.5, DBArtisan 7.2.0, ERwin 4/3.5/2.5, SQL*Loader, SQL* Net, Net8, Easy Configuration, SQL*Trace, TKPROF, DBASSIST, DBCA, DBUA, NETCA, UOI, Oracle DBA Studio, TOAD, Requisite Pro, Veritas NetBackup, TELETRAN, Best1, SQL* Reports 2.0/1.1, PeopleSoft 6/7/8

Hardware: Amazon Web Services (AWS - EC2, S3, SNS), RHEL7, 6.X,5.X, Ubuntu 14.04 LTS, VMWare,Sun 6900/6800/4800, Sun E10K, IBM AIX, Linux Servers, Egenera Gigabit, EMC-8730 / T3/UV disk arrays, SunSparc E-450, HP - 9000 (V-2250), U-6000/35 (Unisys), Pentiums.Windows Servers.

PROFESSIONAL EXPERIENCE:

Confidential, Oakton, VA

Couchbase Database Architect / Engineer

Responsibilities:

• Working on basic database design, schema creation, data modelling and physical database creation from the scratch for Flight Data Control System.
• The data comes from 24 ground entry points (GEPs) and Secured government operation centers. Installation of Postgres and related tools.
• the cluster to setup hot standby database using PostgreSQL streaming replication, PgPool II and REPMGR (for automatic failover).
• Evaluated EnterpriseDB PostgreSQL Advanced Server (9.5) and the EDB tools like EDB Failover Manager (EFM), EDB Enterprise manager (EEM), Migration Tool, and Backup and Recovery Tool (BART). Also, analyzed the Confidential guidelines of STIGS (Security and Technical Implementation Guide) for the flight data control system.
• As Couchbase DBA, created a separate Couchbase Database cluster to store flight control data log information.

Environment: PostgreSQL 9.5, EnterpriseDB (PPAS), Couchbase 4.5.1, RHEL 7, Vmware VCENTER (ESXi), ElasticSearch, Jira, GitLabs, Docker.

Confidential, Herndon, VA

Responsibilities:

• Worked as Couchbase DBA/Architect for Customer Experience Portal and Sales Portal.

Environment: Couchbase 3.0.3, Neo4j 2.3.2 (Graph Database), RHEL 6/7, Amazon Web Services (AWS), Pivotal Cloud Foundry, Puppet, Kafka.

Confidential

Responsibilities:

• Supported as Confidential (3.0) DBA for Military Health Records project of Veterans Affairs (VA).

Confidential, Fairfax, VA

Couchbase Database Administrator / Engineer

Responsibilities:

• Currently working on Confidential Medical Health Records project as Lead Couchbase Administrator / Architect / Engineer.
• The work involved Configuration and installation of Couchbase 2.5.1 NoSQL instances on AWS EC2 instances (Amazon Web Services) of RHEL 6/7,
• Creation of buckets, documents, loading the documents, backups and recovery, sizing the Couchbase, day to day monitoring and maintenance of couchbase clusters in Production, CAT, and DEV environments. Automated backups through shell scripts and scheduled cron jobs for daily backups, weekly archival to S3 buckets on AWS.
• Performed data restores from the backups, failed over the nodes for maintenance of failed nodes, documented all the procedures and SOPs for all the administrative tasks mentioned above.
• Worked with System Admins and security teams to configure the POC for Data Encryption tool Vormetric.
• Installed and configured ElasticSearch and created the index references to Couchbase buckets for replication through XDCR (Cross Data Center Reference).
• Also, used ansible tool to deploy the software on couchbase nodes.
• Used AWS services like EC2, S3, SNS, RDS, EBS etc. to support the project.
• Upgraded the Couchbase from 2.5.1 to 2.5.2 and 3.0.1 in UAT environments.
• Worked on Key Performance Indicator (KPI) SOPs.
• Monitored the performance using the Couchbase Web console and REST APIs (cbstat tool).
• Worked with Couchbase support team for sizing the Couchbase cluster. Also, provided the architectural review and new design, with 6 / 9 / 13 nodes Couchbase cluster, to the client for future enhancements.
• In addition, provided database administration support for PostgreSQL and ElasticSearch (plugin to couchbase). Migrated PostgreSQL database to AWS (RDS).

Environment: Couchbase 2.5.1, PostgreSQL 9.x, 3.x, RHEL 6/7, Amazon Web Services (AWS - EC2, S3, SNS, RDS), Vormetric Data Encryption (VDE), ElasticSearch, Ansible

Confidential, Vienna, VA

Sr. Oracle Database Administrator / Engineer

Responsibilities:

• Working as a Sr.Oracle Database Administrator / Engineer for building a data center for Confidential.
• The work involved developing the databases from the scratch for the data center. Installed Oracle 11g, created the databases, schemas and other users for DHPSIRT, BLADELOGIC, VCENTER (for virtualization), BMC tools, RMAN etc. in Dev, Test and Production environments.
• Setup RMAN hot backups using Linux shell scripts and ComVault SIMPANA backups interface tool.
• Periodically applied Oracle patches(CPUs, PSUs) and other data security implementation to comply with DISA (Defense Information Systems Agency) STIGS (Security Technical Implementation Guide).
• Upgraded the older version of Oracle 11g to the current version 11.2.0.3.
• Upgraded the oracle database from 11.1.0.7 to 12c (12.1.0.1).
• Also, supported the as secondary SQL Server DBA that supports Defense Health Information Management System (DHIMS).
• Performed installation and DB creation, user access control, and setup weekly full, weekly translogs and daily incremental backups through maintenance plans (SQL Server Management Studio).

Confidential

Responsibilities:

• Configuration and installation of Confidential 2.0.4 NoSQL instances on Linux (Ubuntu, Cent OS, RedHat) and Windows platform including AWS EC2 (Amazon Web Services).
• Data loading (mongo export / import) into Confidential database in JSON, CSV formats), creating reports, configuring high availability, backups and recovery.Worked on CRUD operations, creating replica sets and sharding.

Confidential

Responsibilities:

• Installed Apache Confidential on linux servers. Installed Hortonworks Sandbox v2.1 on Oracle VM virtual box (using OVFA - Open Virtualization Format Architecture) .
• and tested various scripts for data processing using pig and Hive, create tables in Hcatalog to load the data.
• Upgrades, periodical patch applications to meet Confidential security requirements.

Environment: Oracle 11g/12c (11.1.0.7 / 11.2.0.3 / 12.1.0.1 ), RHEL 5, Confidential 2.0.4, Confidential Hortonwork v2.1, Amazon Web Services (AWS), WebLogic Server 11g, OEM, TOAD, SQL Server 2008 R2

Confidential, Vienna, VA

Sr. Oracle Database Administrator / Architect

Responsibilities:

• Worked as a Sr.Oracle DBA for client Confidential . The project was to build the Confidential 2010 Paper Based Operation (PBO) Information System.
• As a Sr. Oracle DBA, worked on database design, configuration and implementation of 8 node RAC.
• Created new environments for development, test, acceptance and production. Provided 24X7 production support.
• Monitored the health and performance of the production environment. Used Grid control for monitoring the databases.
• Installed oracle software and applied patches as recommended by Oracle Support to fix the bugs and one off patches.
• Participated in setting up of oracle streams for reporting database. Prepared scripts and setup the RMAN backup level 0 and level 1 (incremental) on weekly and daily basis.
• Also the full analyze and stale analyze were scheduled using crontab.
• In addition, I also worked on standards and procedure for Database naming convention, userids, deployments procedures and directory structures for SVN. Extensively worked on performance tuning using various tools like OEM, TOAD etc.

Environment: Oracle 10.2.0.4, RAC 10g, Red Hat Enterprise Linux Server release 5.4 (Tikanga), OEM Grid control, TOAD, Shell Scripting, SubVersion (SVN), Egenera Gigabit

Confidential, McLean, VA

Sr. Oracle Database Administrator / Architect

Responsibilities:

• Currently working for DOL as a Lead Sr. Oracle DBA / Architect. The project is to redesign the OSHA (Occupational Safety and Health Administration) Information System (OIS).
• As a DBA/ Architect, I am working on database design, hardware and software requirements, installed oracle software 10.2.0.1 and upgraded to 10.2.0.3, created of physical databases, created databases for OIS system, configuration management (ClearQuest and RequisitePro) and migrated the data from older CM system, data architecture / data modeling using ERWin.
• Working on design / preparion for 2 node RAC in the same environment.
• Worked on standards and procedure for Database / Hosts naming convention, user ids, password policies and directory structures. Also documented hardware and software configurations.

Environment: Oracle 10.2.0.3, Sun Solaris 10, SunFire T2000, SunFire v490, BEA AquaLogic,Alfresco, ERWin, TOAD, OEM, Shell ScriptingConfidential, McLean, VA

Sr. Oracle Database Administrator

Responsibilities:

• Worked as Lead DBA for data warehouse project which includes a corporate data warehouse and data marts “Instaknow data warehouse” and “Instaknow data mart”.
• These databases basically track the information pertaining to the contracts based on the data from the source systems such as JAMIS, TOL and HRIS. In addition to data warehouse I was also part 24X7 support DBA team of 5 DBAs and maintained other production databases.
• Created the new databases and assisted developer teams for loading/refresh the data. on regular basis as well as on demand.
• Automated most of the load jobs, monitor jobs and backups using korn shells, provided day-to-day support to the developer and ETL(DataStage) team for QA, TEST and finally rolled over to production.
• Pro-actively checked the database health and disk space management.
• Assisted developer team for tuning the SQL queries. Security administration for users by creating roles, profiles and password policies. Setup 2 node RAC with ASM.
• Provided the RAC DBA support for performance tuning, load balancing, and maintenance of RAC nodes.
• Upgraded the databases from Oracle 9i to 10g. Installed oracle 11g in test environment.
• Setup oracle streams for replication of selected tables.

Environment: Oracle 11g/ 10.2.03/9.2.0.7, Oracle RAC 10g, Oracle 10g AS, TOAD, DataStage (ETL Tool), OEM, PL/SQL, Unix shell scripts, Windows 2005, SQL Server, AIX, Sun Solaris and Linux Servers.

Confidential, Sterling, VA

Sr. Oracle Database Engineer/Architect

Responsibilities:

• As a Sr.Database Engineer, mainly responsible for providing various database solutions to the clients.
• Some of the major clients include Accenture, EDS, Canon (UK), Canon (Japan), Canon (US), ATS, Future Network, Infinity and so on.
• The nature of job involved providing the database solutions to meet client requirements that includes Installation of Oracle software, Installation of RAC on 5 nodes, with ASM, Oracle DataGuard 10g(standby), Grid Control
• Installed and tested 11g on test database, providing High Availability solutions, backup and recovery solutions, upgrading the databases, applying the critical patches and security patches periodically when required.
• Training: Oracle Application Server 10g from Oracle Corporation.

Environment: Oracle 11/g, 10g,/ 9.2.0.7/8.1.7.4, TOAD, RAC, ASM, Oracle10g, Grid Control, Oracle 10g Application Server, Netbackup 6.0, PeopleSoft, ClearQuest, OEM, PL/SQL, Unix shell scripts, Windows 2005, SQL Server, AIX, HP-UX, Sun Solaris and Linux machines.

Confidential, Reston, VA

Sr. Oracle Database Administrator

Responsibilities:

• Worked in restatement project in nightly shift to support production databases as a primary Oracle DBA.
• The day to day activities include database creation, oracle upgrades, performance tuning, security administration, user support, deployments, backups and recovery of databases.

Environment: Oracle 10g,/ 9.2.0.7/8.1.7.4, TOAD, Oracle 10gRAC, PeopleSoft, ClearQuest, OEM, PL/SQL, Unix shell scripts, Windows NT, Sun Solaris.

Confidential, Reston, VA

Sr. Oracle Database Administrator

Responsibilities:

• Confidential conducts SAT exams all over the world. It has developed various systems to operate the student registrations, online registrations, examination schedules, announcement of the results, accounting and so on. Working as production DBA for all SAT related applications (OLTP systems).
• This application has users all over the world. Also, setup single node RAC and Oracle streams for replication.
• Worked as a Sr. Oracle DBA supporting production, stress, qa, training and development databases.

Environment: Oracle 10g,/ 9.2.0.6/8.1.7.4, TOAD, RAC, Veritas Indepth, Quest Qcentral for Oracle, OEM, PL/SQL, Java, Shell Scripts, Perl, Windows NT, Linux Servers (RedHat 2.1), IBM AIX, Sun Sparc (Sun OS 5.8), Net App (NAS).

Confidential, Oakton,VA

Sr. Oracle Database Administrator

Responsibilities:

• Worked as primary DBA for EOSCAR an OLTP system.
• This project has nationwide users (around 15000) and deals with consumer dispute verification.
• The major clients are Experian, Transunion, Wachovia, SEARS and so on.

Environment: Oracle 9.2.0.5/8.1.4, TOAD, OEM, PL/SQL, Java, Shell Scripts, Windows NT, Sun 6900 (Sun OS 5.8), Sun 4800, EMC T3 and UV disk arrays.

Confidential, Bethesda MD

Sr. Oracle Database Administrator/ Lead DBA

Responsibilities:

• Worked as Sr. Oracle DBA/ Lead DBA to build an enterprise-wide operational data store (ODS) for Confidential . ODS an integrated database which has the characteristics of both Data Warehouse and OLTP. The input for this database will be from 39 different data sources on various Platforms.
• As a part of ODS team and primary DBA involved in all the steps of building ODS, including Logical modeling, Physical modeling, design and creation of databases for test, development, ETL, acceptance and production. Supported ETL team for extracting data from various data sources, supported development and testing teams for access control, security administration, created objects like views, indexes, and procedures, tuned the database for better performance, prepared the shell scripts for logical backups and copying the schemas.
• Prepared the standards for attributes and other objects.
• Modified the database objects and attributes as requested by PRs (using Rational Clear Quest). Used the tools DBArtisan, TOAD and ERstudio for database administration and modeling.
• Wrote several shell scripts to automate the process of data loading, backups, conversion, production mirrors and copying the pre-prod schema to prod and reporting schemas.
• Prepared the JIL scripts to automate the above processes through AutoSys and integrated with ETL processes.

Environment: Oracle 9.2.0.4, DBArtisan 7.2.0, DBStudio 5.5, TOAD, PL/SQL, Shell Scripts, Java, Business Objects 5.1, Windows NT, Sun OS 5.8.

Confidential, Herndon, VA

Sr. Oracle Database Administrator

Responsibilities:

• Created standby databases from RAW devices on two separate remote servers with manual recovery for AMDOCS Ensemble billing system.
• Managed the standby database with manual recovery by applying the archived logs on daily basis.
• Installed Oracle 9i on unix boxes.
• Day to day data migration refresh (export / import of large partitioned tables ), creating the schemas, views, table partitions, index partitions and other database objects. Space management, proactively generating space alert reports, security administration, creating views from BCVs .
• High level (Oracle Internals) Performance tuning of applications and database while exploring the new features of Oracle 9i
• Prepared project work books for the servers and standby databases.
• Capacity planning for all the databases on Sun and HP boxes.
• Implemented security management policies for databases. Security password policies were implemented using the profiles and verify functions.

Environment: Oracle 9.2/8.1.7,TOAD, PL/SQL, PeopleSoft 8, Shell Scripts, HP-UX, Windows NT, HP-9000 ( V-2250), Sun 6800 (Sun OS 5.8), Sun E10K, EMC 8730 (32 terra Bytes).

Confidential , DULLES, VA

Sr. Oracle DBA Manager

Responsibilities:

• Backed by the resources of Bertelsmann AG, Benefit Nation is a provider of electronic and paper based publishing services for healthcare, pharmaceutical and financial services.
• As a lead DBA manager managed DBA team, System Administrators and a Network Administrators. Responsible or the implementation of COTS (Documentum Confidential ), all the databases (production and development) and database group. Reported directly to the chief technology officer. (CTO).

Environment: Oracle 8.1.7/9i, Oracle Enterprise Manager, Oracle DBA studio, Documentum 4.2, Solaris (SunOS) 5.8, IPlanet Webserver 6.0, BEA WebLogic 6.0, Java, Visual Basic, LDAP, RequisitePro, Clear Case, PR-Tracker, Veritas NetBackup, 3-Tier architecture.

Confidential

Principal Consultant

Responsibilities:

• Worked for Paragon for five years as Principal Consultant and staff manager, during which provided the services to the following clients, Confidential