Database Architect Sr. Database Administrator Resume
CA
SUMMARY:
- 20+ years of Information Technology with right balance of management and technical skills to work effectively in a team and across cross functional groups.
- 12+ Lead Data Architect/ Data Modeler / Application/ Production Oracle DBA for enterprise databases and warehouse environments working with Global clients at all levels to understand Databases, data, process, and program requirements for large - scale, highly complex projects involving Oracle and multiple enterprise systems on Unix and Heterogeneous platforms.
- 10+ Years Project Management Experience Manages Global clients in Government, Banking& Financial, Government, Insurance, Mortgage, Health care, Hospitality sectors. Coordinating all stages of the project lifecycle for complicated technical implementations and Agile methodologies.
- Application Development designing various industrial applications.
- Maintain Projects and enterprise data dictionary.
- Developing and enforcing data modeling standards and best practices,
- Managing the enterprise data models & Meta data.
- Knowledge of FSDF, Documentation, Dimensions, Key Reporting Tables Design & Data Flow.
- Knowledge on SPARX - enterprise architecture visual modelling and design model tool.
- Expertise knowledge in Enterprise Data Integration, Data Warehouse, Data Quality, Data Migration & DATASTAGE & Data Lakes.
- Knowledge & Hands on Data mover scripts in PeopleSoft.
- Knowledge and understanding of Oracle Life Sciences Data Hub.
- Knowledge on how to build reusable, automated applications to load data from an Oracle database, or text file and merge and transform data using PL/SQL, or Informatica
- Data Modeling, Relational Mappings, Conceptual Models, DFDs and ERDs using Oracle Designer.
- Experience in Data modeling and architecture at enterprise level.
- DW architecture and modeling using CA ERWIN tool.
- 24x7 Oracle Production Database support to various High Availability in Banking, Insurance, Hospitality, Healthcare and Energy applications.
- Service Level Agreements (SLA) on Incidents, Change Requests & Critical calls.
- Build out of the Data Warehouse, Data Marts and Operational Data Store
- Implemented Database Up-gradation and Migration Projects.
- 10 years of RMAN experience on Oracle Production Databases
- Configured and Implemented Automatic backup techniques using Legato & RMAN - EMC's backup, exp/import & Data pump.
- Expertise in UNIX shells scripting for backup and handling of AUTOSYS jobs.
- Performed Database Refresh from Production to QA and Development databases.
- Managed Databases of large Terabytes of Data.
- Performed Transportation of table spaces for Major Data warehousing Databases.
- Involved in Database Designs and Optimization techniques.
- Production support to Oracle Financial Applications ( OFSA ).
- PL/SQL script creation and tuning, Procedures, Functions, Triggers.
- Manage all database objects in a large mission critical system
- Shell scripting, performance, and tuning, Analyze and resolve complex technical problems.
- Monitor databases and performs tuning enhancements to optimize their performance.
- Other Relational databases like Postgress, SQL Server, DB2 and IBM UDB.
- Knowledge of ERP systems like Oracle 11gR2 & R12
- Production DB support to Highly Critical Applications in the Banking sector customer, product, service.
- Programming expertise in Oracle PL/SQL, Pro*C, C and Oracle triggers, stored procedures, and functions.
- Teradata Database expertise.
- Worked on Oracle Developer Forms, Reports and Menus.
- Successfully handled Onsite offshore support Models.
AREAS OF EXPERTISE:
- Database Administration
- Data Modeling
- Project Management Project Delivery
- Requirements Management Technology Deployment & Migration Presentations
- Program Management Team Building & Leadership
Domain Expertise: Banking & Financial Services, Payroll, Inventory, Purchase Management Systems.
RDBMS: Oracle 12c,11gR2,10g and lower versions. MS SQL Server 2008, MySQL, Teradata Postgres, UDB IBM Db2, Data warehouse Data Quality, Migration, DataStage, Data Mover Scripts of Peoplesoft, Informatica, data marts, WarehouseInformatica Power Center, LSH - Oracle Life Sciences Data Hub AWS Cloud Redshift
Modeling Tools: DFD & ERDs, Designer 2000, Erwin, ER Studio, CA Rally
Project Management Tools: HPPPM, MS Project Word.
High Availability Solutions: Real Application Clusters 11gR2,10g, ASM, Data Guard.
Performance Tuning Tools: Oracle OEM 12C, Toad, Tkprof, SQL Analyzer, AWR, ADDM
Reports, Explain Plans, SQL Profiles:
Operating Systems: Red-hat Linux 6, AIX, SCO, Sun Solaris and Windows.
Languages: SQL, C, Pro*C, PL/SQL, Procedures, Functions, Triggers, Shell Scripting, Java, PHP, Python
Backup Tools: RMAN, Legato, Data-pump, exp/Imp
ERP Oracle Applications: 11i GL Module, Oracle Banking Application. OFSA Oracle financial Application.
Processes: Project Management, ITIL, SDLC, Agile, Scrum
PROFESSIONAL EXPERIENCE:
Confidential, CA
Database Architect Sr. Database Administrator
Environment: Oracle 12c, OEM, Maria DB, SQL Server 2016, MySQL, Maria DB, AWS Cloud, CA Rally, ER Studio
Responsibilities:
- Analyze and design the database.
- Meeting with Developmental teams and discuss the design changes.
- High Level and detailed design documents to prepare.
- Analyze the old database fields to the new.
- Status update to Managers, developers, and Project managers.
- Manage Client meetings for Business Requirements and manage Business Forecast.
- Daily evaluation of User stories from the Sprint following Agile methodology.
- Prioritize the Models required to be designed as per the criticality to the user.
- Create conceptual, Logical, and physical models and compare database and model.
- Implementation of physical Database designs.
- Database Implementations and Migrations, Installations, and configurations techniques.
- Perform data profiling and data analysis
- Source target mapping.
- Maintain and project business rules and the associated enterprise data dictionary
Confidential, New York
Data Analyst
Environment: MS SQL Server, Aws cloud, Hadoop, TSQL, Data Lakes & BI, Data Pipelines, ETL Teland
Responsibilities:
- This project, Data Pipeline is about an enterprise data platform comprising several databases and software components. It is used to intake and process a variety of data from healthcare payers and providers
- Develop a QA framework to ensure accurate, consistent, and repeatable process for validating data across data ingestion, transformation, and enrichment phases of processing. QA engineers will need to be deployed as part of the scrum teams to assist with test design and development of the data pipeline tests.
- Data flows from Source Layer to RAW Data Lakes and Data transforms into Data to EDW and Lake and from there goes to EDW and then to Data Analytics or Data Mart.
- Design the Data Testing strategy across the enterprise System.
- Building Data Warehouse and Data Mart solutions.
Confidential
Data Architect/ Design & Model - Agile Methodology
Environment: JIRA, Confluence, Remedy, Erwin, Informatica, Oracle
Responsibilities:
- Creation of Data Warehouse, Data Marts and Operational Data Store.
- Designing views & Database objects using 3 Dimensional models.
- Follow key aspects of ITIL framework - Change, Incident & Problem Management.
- Manage Databases Changes for Emergency, Fast Track and Normal Change Request.
- Approve Changes for Database
- Provided input and feedback regarding ETL processes.
- Working with CM DB databases.
- Processing CRQ’s and follow approval processes. Attending Approval meetings like DCCB, ECAB & Change Advisory Board (CAB).
- Selected to plan, organize, and manage maintenance repair methodologies to achieve desired scalable leveraged Remedy Application.
- Coordinated with multiple teams to identify potential system compromise issues.
- Managing and defining Change Management Processes and Quality Control for Databases,
- Team Building and Metrics, Work Breakdown, Distribution of Work
- Design, continual improvement, metrics & Service Delivery
- Operations, Compliance, Relationships
- Project to Manage Implement Remedy 9 at the enterprise level Change Management Application.
- Manage Pre-approved changes (Fast Track Process) & Emergency Changes
- Co-ordinating with remote teams, Project Status, and resource allocation.
Confidential
Data Architect/ Project Manager
Environment: Oracle Banking Platform (OBP), MDS, OFSA, Ab Initio, Microsoft Project, Visio, Share Point & Excel, WebLogic, Oracle 11GR2.MDS, Informatica Power center, PL/SQL, Erwin
Responsibilities:
- Rapidly accessed needs and identified/ resolved potential issues while effectively communicating with Key account representatives.
- OFSA requirements. User stories and Business requirements. knowledge and experience with the latest data technologies and frameworks such as Hadoop, MapReduce.
- Documents preparation with relational physical models and financial applications.
- Plan monthly reports and Monthly refresh.
- Provided technical guidance to assigned project teams.
- Allocated and coordinated within a team project.
- Develops test cases, scenarios, and scripts to ensure applications quality.
- Planning & Executing Mock conversions with test data before final conversion.
- Creating Dashboards for Project Progress.
- Build out of the Data Warehouse, Data Marts and Operational Data Store
- Dimensional Modeling, Star and Snowflake Schemas design and maintaining dimensions using Slowly Changing Dimensions.
- Maintenance of Development and test Databases.
- Perform data profiling and data analysis.
- Prepare process models to document data and information flows for sourcing and accessing warehouse data
- Developing data lineage and source to target mapping
- Design conceptual, logical and physical data models
- Design views and dimensional structures based on the 3NF model
- Prepare fully refined data models in accordance with complete metadata
- Co-ordinate with Offshore team and be accountable for success of team
- Creation and Implementation of Test and Develop environment.
- Working with Infra structure team for capacity planning.
- Effective communication with stakeholders and coordination between teams.
- Working Oracle Corporation team.
- Project initiation, Budget estimation, Planning
- Project Resource allocation, effort estimation and timely updating the project status in terms of timelines progress, available funds.
- Identify the risk, risk analysis, and provide baseline acceptance criteria and deliverables.
- Project status updates in Agile methodology.
- Providing Analytical Support to key business Applications /solutions.
- Co-ordination between onsite and offshore teams. vendors, moderating project Meetings, authorizing Project Minutes, and tracking milestones/issues/risks.
Confidential
Data Architect/ Project ManagerResponsibilities:
- Manage all the Infrastructure Projects and Data Center Migrations.
- Management for migration of 1600 Application for HP.
- Project Management, Project Schedule, Project Tracking and Team Management.
- Manage Projects from initiation stage to project Closure.
- Proactive steps and meetings to understand client requirements.
- Define Business Process, identify the risk, risk analysis, and provide baseline acceptance criteria and deliverables.
- Providing Analytical Support to key business Applications /solutions.
- Presentations to both technical and non-technical audiences
- Manage reports, analysis, and decision-making for a change request.
- Co-ordination between onsite and offshore teams.
Lead Database: Database Architect
Confidential, Hartford
Environment: Oracle 12c, 11g, 10g, OEM, SQL *Loader, TOAD, SQL Advisor, Share plex, Exadata Machines, PL/SQ, Shell Scripting, Hadoop file systems.
Responsibilities:
- . Provided support provided to end users on day to day issues related to BI - reports & ETL.
- Convert logical data models to Physical databases.
- Architectural and Modeling support to all the Oracle Application and BI databases, Reinsurance and Wealth Management Applications.
- Managing complex line of Businesses Re-insurance and IM data warehousing Systems.
- Serve as primary contact for customer inquiries and concerns.
- Co-coordinating with Development & Client Tech team and develop conceptual/logical and physical Models.
- Implement and create physical Databases.
- Implement database objects like Procedures, Functions and Triggers.
- Report delivery status to customers and develop required delivery documentations.
- SQL performance tuning and optimization techniques
- Designing of Database support documents for Team.
- Translate business requirements to Data Reporting services.
- Assist & Advice applications teams on performance tuning and resolve performance bottlenecks.
- Processing CRQ’s and follow approval processes. Attending Approval meetings like DCC, ECAB & Change Advisory Board (CAB).
- Follow key aspects of ITIL framework - Change, Incident & Problem Management.
- Lead Point of contact to two Major applications.
- Complete Knowledge Transfer Phases and stabilize the Applications and involved in designing and review of Knowledge Transfer.
- Manage and co-ordinate with Onsite offshore support Team.
- Application & Sysdba support to multiple environments and Databases.
- Resolving incidents and CRQ’s related to applications and avoid SLA breach.
- Complete Refresh from Production to QA, Dev and SIT environment.
- Database activities related to performance Tuning, Data Fixes, Monitoring backup and Batch jobs, Tracing, assistance to Monthly & yearend jobs and activities.
- Participate in status meetings with application team & Management.
- Managing Critical calls and timely response to emergency calls.
- Interact with other support teams like Server, Storage, Network towers.
- Co-ordinate with Application Developers, DBA’s, Infrastructure team, backup and restore team, System & Remediation, Audit and Change Management Teams.
Confidential, Maryland
Lead Oracle Data Architect /Modeler /Admin
Environment: Oracle 9i,10g,11G, Postgres SQL, Pl/SQL Legato Networker Servers, Linux RHEL 6, Erwin
Responsibilities:
- Monitor databases and performs tuning enhancements to optimize their performance.
- Database support to Production& Applications.
- Create conceptual/logical and Physical data models and
- Query Pl/ SQL tuning.
- Implement DDLs
- Design data Models and implement procedures, functions, and Triggers into Database.
- Database consolidation.
- Convert logical data models to Physical databases.
- Responsible for designing and supporting Oracle related functionality, providing the highest possible performance, availability, and security techniques. Worked closely within the Data center.
- Responsible for activities related to integration, including creating audit reports that verify all source-database data exists in the consolidated databases.
- Configuration management, backup/recovery, performance optimization, and capacity Management.
- Patching and Upgrade skills in production environment.
- Tuning audit/SQL queries so that they perform well, maximizing system operations based on the hardware.
- Merging databases and handling Migrations.
Project Lead / Data Architect
Confidential, Dayton, OHIO
Responsibilities:
- Analyze and design the database.
- Meeting with Developmental teams and discuss the design changes.
- SQL performance tuning and optimization techniques
- High Level and detailed design documents to prepare.
- Analyze the old database fields to the new.
- Status update to Managers, developers, and Project managers.
- Manage Client meetings for Business Requirements and manage Business Forecast.
- Project Requirement study, High Level & Detailed design & Unit Test Cases.
- Designing of Entity Diagrams, Data-flow Diagrams.
- Designing logical and physical model.
- Data Modeling and Database Design.
- Understanding Oracle Application Order Management Module (EBS).
- Manage Deliverables on time.
- Prepare Test cases, Test Scenarios, Plans for all interface modules of the entire forecasting Model.
Data Warehouse Project: Architect
Confidential
Environment: Oracle Teradata, Unix, Peoplesoft, Informatica
Responsibilities:
- Manage technical team for Peoplesoft, Informatica, Database and staging Area & DBA.
- Dimensional Modeling, Star and Snowflake Schemas design and maintaining dimensions using Slowly Changing Dimensions.
- Leading the technical team at the client site and update Project progress to client.
- Manage and build productive working relationships with client.
- Building Data Warehouse and Data Mart solutions
- Primary contact for customer inquiries and concerns.
- Customer meetings to understand for there are any further improvement.
- Manage team to ensure timely deliverable to customer.
- Provide direction and guidance to the Delivery Team.
- Unix Shell Scripts to extract data from Mainframe to Staging Area.
- Data Loading Using Informatica 5.1 to extract from Staging area.
- Shell Scripts Automate the Entire Informatica Loading.
- Implementation of automation Scripts in TWS Automation Software.
- Production Support for weekly DataMart’s.
- Data Mover Scripts for People Soft Applications.
- Design Logical and Physical Models and participate client meetings.
- UNIX Scripts and Informatica 5.1 scripts generation to extract the data.
- PL/SQL procedures.
- Shell scripts to extract data from legacy systems to Oracle Databases of DataStage
Lead Oracle DBA - Oracle Production DBA/Data Modeler
Confidential, Columbus Ohio
Responsibilities:
- Daily Monitoring of the Database.
- Transformation of Tablespaces.
- Managing DBA team of 5 Technical consultants.
- 24x7 Production support to 46 Databases.
- Database Health Check
- Database Design & Creation
- Managing Backups & Recovery, Security, Users, space Management
- Database Performance Tuning.
- Data Loading from External Sources using SQL Loader
- Transportation of Tablespaces & Table Partition
- Creation Database Links
- Suggestions to senior Management about Database Health
- Capacity Planning
- Month end Roll of Data warehousing Data of OFSA.
- Installation of patches.
- Tnsnames.ora Rollout
- Team Management.
- Manage Deliverables.