Data Warehouse User Experience

Location:

Ashburn, VA

Posted:

November 04, 2024

Contact this candidate

Resume:

Vijay Mooka

Manakin Sabot, VA *****

**********@*****.***

+1-804-***-****

Tech Lead/Cloud Architect/DBA with a strong track record in leading major upgrades and migrations of enterprise applications like Peoplesoft and Oracle, significantly enhancing system capabilities and user experience. Expert in implementing clustered database environments and advanced load- balancing solutions using technologies like HP-UX, Sun Solaris Unix, BIGIP, and WebLogic. Skillful in developing and enforcing security standards, managing global support, and optimizing OLTP and data warehouse databases to ensure robustness, high availability, and compliance across multiple international environments. Demonstrates leadership in database design, performance optimization, and system scalability, with a proven ability to lead technical teams and manage complex projects from conception through execution.

Willing to relocate: Anywhere

Authorized to work in the US for any employer

Work Experience

Lead Platform Engineer

Capital One-Richmond, VA

February 2002 to April 2024

Directed a cross-functional team of Confluence administrators and developers, fostering a collaborative and innovative work environment. Coordinated with IT, DevOps, and business teams to understand requirements and deliver customized Confluence solutions that meet organizational needs. Trained and mentored team members on Confluence best practices and advanced features, elevating overall team expertise and performance.

• Spearheaded major upgrades for Peoplesoft Finance and Portal modules, enhancing financial systems capabilities and user portal accessibility; successfully managed the transition from Tools release 8.1.8 to 8.45 and application 8.8.

• Led a technical team in implementing clustered database environments within a secured HP-UX and Sun Solaris Unix shop, utilizing BIGIP for monitoring connections and WebLogic for effective load balancing.

• Orchestrated the database migration and upgrade strategy, transitioning from Oracle 8.1.7.4 to 9.2.0.5 across multiple environments including Production, QA, and Development, ensuring system robustness and data integrity.

• Developed and enforced security standards across all database environments, significantly enhancing data protection and compliance; authored comprehensive documentation to standardize DBA practices and improve team mentorship.

• Played a pivotal role in the physical and logical design of OLTP and data warehouse databases, utilizing tools such as ERWIN for design and implementation in production environments, thereby optimizing data management and access.

• Provided 24/7 global support for app servers and database operations, troubleshooting network connectivity, port mismatches, and server performance, ensuring high availability and minimal downtime for US, UK, and Canada users.

Database Administrator:

Spearheaded major upgrades of Peoplesoft Finance and Portal modules, significantly enhancing financial system capabilities and user portal accessibility by managing the transition of tools and applications. Led a technical team in implementing clustered database environments, orchestrating complex database migrations, and developing robust security standards across platforms, ensuring system robustness, data integrity, and high availability for global operations.

Database Administrator

Aventis Pharmaceuticals-Bridgewater, NJ

2001 to 2002

Administered global Oracle database environments, overseeing maintenance, backups, recovery, and the creation of new instances, while leading successful migrations and upgrades to optimize system performance. Engaged in comprehensive database management activities, focusing on performance optimization, storage management, and robust system support, enhancing productivity and ensuring system reliability across production, development, and testing environments.

• Administered global Oracle database environments, executing essential tasks including maintenance, backups, recovery, and the creation of new instances, while successfully migrating all instances from version 8.0.5 to 8.1.7.

• Led upgrade and application tuning for multiple instances, transitioning from ActivityBase 4.0 to ActivityBase 5.0in collaboration with end-users to optimize queries and adapt configurations to new structural and model changes.

• Focused on performance optimization and storage management, implementing strategies that enhanced productivity and reduced system contentions in production, development, and testing environments.

• Engaged in comprehensive database management activities, including physical design, application support, patch application, and migrations, ensuring robust system performance and reliability. Peoplesoft/Oracle Administrator

ＨＩＰ-New York, NY

2000 to 2001

Worked as Peoplesoft/Oracle Database Administrator. This role holds very ambitiously defined tasks such as sole in charge of implementation of different HRMS modules in production environment like Benefits Administration, Tuition Assistance etc., and also maintaining the Financial Modules on production and development environments for Health Insurance Plan of NY. Configuring, Maintaining, Tuning, Refreshing Production, and several development databases, working closely with several department heads, and development teams to facilitate a smooth and successful implementation. Defining the plan for upgrading of the application and the people tools to 8 and 7.6, applying patch. Worked on the system requirements, planning for implementation of the upgrade to peoplesoft 8. Configured application server, process scheduler, tuxedo servers pushing objects from development to production adhering to the change management, constantly pursuing to improve performance and resolving bug issues with both Oracle and Peoplesoft. Playing a vital role in moving forward with reference to both the application upgrade, database upgrade, and over all system upgrade. Developed strategy & recommendations with reference to the system architecture, backup etc., Worked extensively on the physical design of oracle databases. Database Administrator

Aventis Pharmaceuticals-Bridgewater, NJ

2000 to 2000

Worked as an oracle database administrator on a production /development environment solely responsible for the backup, recovery, upgrade, installation, implementation of databases to various stages. The assignment involves interaction with multiple users/developers in multiple sites spread over in Germany, France, UK and USA. Very dynamic and sensitive pharmaceuticals research data growing massively always demanding constant monitoring and attention. Involved with the server/database tuning interacting with the developers in the application tuning and other issues with respect to network processes. Also involved in application migration and upgrade providing support as DBA. Involved in planning as a DBA. Making key decisions with multiple projects, planning on their system requirement, designing their Datawarehouse system, functional approach and cost approach. Built, Configured, Installed Oracle 8.1.6 on SGI and implemented it in production successfully with the great turn around time. This process required careful planning and various interactions with the application consultants, developers, and end users. Built databases from scratch and implemented backup strategy computed future space requirements and set the databases on production after effective testing successfully.

Peoplesoft/Oracle Database Administrator

Citicorp-Tampa, FL

1999 to 2000

Worked as an oracle database administrator with Peoplesoft HRMS application running on a multiple instances “Global” environment. Working as Peoplesoft/Oracle DBA responsible for tuning of more than 30 oracle databases out of which four are on production 7X24 where hr modules are used to access vital data from all over the world. Also involved in refreshing instances as per requirements, working with developers in pushing objects from test to stage to production, moving and renaming database files as part of strategy of maintenance, working with the end users helping them tune their application queries, performing exports and imports, recoveries where necessary. Also working with third party tools like Quest, Braintree Password Server, and Platinum TSReorg to ease our tasks for better productivity. Peoplesoft/Oracle Database Administrator

CPC International-Long Island, NY

1999 to 1999

Worked as a Peoplesoft/Oracle DBA for CPC International Bestfoods Inc (Group of Philip Morris, Kraft Foods, and Ententments) Bay Shore Long Island NY responsible for backup/restoration maintenance, configuration, upgrade, license, third party tools evaluation. It is a very dynamic, multiple database environment which is primarily using peoplesoft application 7x. One database on production running on archivelog mode, with peoplesoft application 704 running on application server, and multiple instances running on different nodes with stage and development environment using peoplesoft financial and hr modules version 754. Also administering 2 NT databases with 7.3.2 version oracle running. Some of the primary responsibilities are moving projects and peoplesoft codes to different environments. Monitoring the Cron with respect to process schedulers and application servers keeping it up and running. Working with peoplesoft consultants and developers with upgrading the application from 704 to 754. Implementing the updated SQR to production and development environments. Working with the end users on issues related to performance and connectivity both in peoplesoft and oracle. Working with oracle and peoplesoft related to TAR and bugs prevailing in the versions we are currently using. Releasing instances from production to stage for developers to access it for testing modified codes. Involved in the Y2K testing of volume tracker and completed the testing on schedule. Database Administrator

AT&T-Short Hills, NJ

1997 to 1999

Worked as an Oracle DBA in production/development environment for FLASH project in AT&T which has its front-end application as HOLOS6 accessing Oracle 7.3.2 and Oracle 8.0.4. Solely responsible for administration, maintenance, backup, recovery and security of 3 ORACLE databases, tables and other database objects. Frequently using UNIX shell scripts invoking SQL*LOADER loading the tables, creating and managing 250 users, interacting with the front end developers and backend programmers tuning queries and databases. Monitoring database performance, capacity planning, startup, shutdown and other standard DBA activities using Oracle Enterprise Manager. Created databases for development/ testing of partition option in Oracle 8 to compare the performance of 8.0.4:7.3.2. Keeping abreast with the technology and business requirements recommending oracle products. Migrated oracle databases from 7.3.2 to 8.0.4. Configured database with parallel query option for optimum utilization of server resources. Using Oracle Enterprise Manager Tools to analyze tables and tune application queries identifying as to creating indexes to improve performance. Provided support to backend programmers and front-end developers in writing application codes.

Education

M.B.A.

Annamalai University - Chidambaram, Tamil Nadu

July 1984 to November 1987

Skills

• Microsoft SQL Server

• SQL

• MySQL

• Load Balancing

• AWS

• Scripting

• Linux

• Git

• S3

• Oracle

• Jira

• Shell Scripting

• Data modeling

• PostgreSQL

• UNIX

• Microsoft Windows Server

• PeopleSoft

• Confluence

• InVision

• SAS

• IIS

• Weblogic

Contact this candidate