Oracle Dba Developer Resume
TexaS
Summary
- 6+ years of experience in the field of Database Technology with experience in designing, developing, implementing Databases, Web development and Application development.
- Experience translating business requirements into conceptual, logical, and physical data models
- Management and implementation of database models, data flow diagrams, database schemas, database scripts, DTD schemas, structures and data standards to support a robust data management infrastructure.
- Experience on Metadata definition, implementation and maintenance, new business rules identification and implementation to data rules, transformation program library maintenance, XML file generation and data quality.
- Adept at routine Database Administration tasks including automated installation, creation and replication of databases, management of tablespaces, logs, grants, roles, users, indices.
- Working experience of defining triggers events, cursors, stored procedures and packages.
- Working experience in database cloning, data warehouse,database backup, recovery procedures and security.
- Experience in application Support, SQL Loader, Data pump, Data Guard,Fine Grain Auditing(FGA), performing Flashback, transportable tablespaces.
- Experience in configuring Oracle network, RMAN, Recovery Catalog, and Performance Tuning of database by optimizing SQL and PL/SQL scripts and instance. Used statspack report, AWR report,ADDM advisors, autotrace and execution plan.
- Better understanding in Decision Support System (DSS),Software Development Life Cycle (SDLC) and project methodologies.
- Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Database Management Systems
- Oracle RDBMS - 11g, 10g, 9i, 8i
- MS SQL Server RDBMS 2000/2008
- MYSQL 4, 4.5
Relational Data, Object Design Tools
- Erwin
- Toad Data Modeler
- ER Studio
- Visio
- UML
Web Development
- ASP.NET
- HTML/DHTML
- XML
Data Replication
- Oracle Streams
- Oracle Data Guard
- Golden Gate
Data Management Tools
- Oracle Import
- Oracle Export
- SQL*Loader
Specialized Skills
- Logical & Physical DBMS Design
- DBMS Administration
- Real Application Architecture (RAC)
- DBMS Performance Monitoring & Tuning
- Project Management
Information Technology Training
- DBMS Administration
- DBMS Performance Monitoring & Tuning
- Architecture Design & Development
Web, Application Server
- Oracle Application Server
- Apache/HTTP Server
Oracle
- ASM
- Recovery-Backup/Recover
- High Availability - 9i/10g
- Data Guard- MAA
- RMAN
- Replication
- Data Warehouse DBMS Performance Monitoring & Tuning
Architecture
- Technical Architecture
- Data Architecture
- Application Architecture
- Support Architecture
Programming Languages
- C/C++
- Java
- PL/SQL
- UNIX Scripting
Operating Systems
- Sun Solaris
- HPUX
- Red Hat Enterprise Linux
- Windows 2000/2003
- Windows XP
- Windows 2003 64 bit
Big Data Solution
- Hadoop
- Cassandra
- NoSql
Confidential, South Lake, Texas Sep 2009- till date
Data Architect/ Modeler
Responsibilities
- Translate business requirements and enterprises into long-term data architecture solutions, including logical, conceptual, and physical models.
- Responsible for defining and maintaining best guidelines and standards for metadata, data, data modeling, and management.
- Defining, designing, developing and optimizing ETL processes for enterprise data supports in data replication.
- Physical deployment of databases in different environments with automated DDL and DML scripts.
- Support the maintenance and operations like schema updates, modifications, and data load in database level.
- Design standards for using normalized data structures, de-normalized structures, and dimensional structures.
- Defines common design patterns for modeling various types of relationships.
- Reporting and tracking database, architecture and application updates and changes using Enterprise standard JIRA tool.
- Support in application validation, participate in quality assurance, develop and test application code in client server environment.
- Develop understanding of client's original data and storage mechanism.
- Provide technical leadership and mentoring to the functional team.
- Support operational staff as needed to troubleshoot performance problems and application bugs.
- Involvement with CTO and Core Architecture team to leverage industry best practices for database and process modeling, meet Enterprise standards and naming conventions.
Environment:
Database: Oracle 10g, 11g, MYSQL 4.5
OS: Red Hat Linux 5.0, Windows Xp
Other tools: CA Erwin, Toad for Oracle, Oracle ODI, Crystal Report, Microsoft SharePoint, Version One, Tortoise SVN
Confidential, Framingham, MA June 2009- Aug 2009
Database DBA / Architect
One of the world's leading biotechnology companies, Genzyme is a leader in the effort to develop and apply the most advanced technologies in the life sciences. My major role in the project is to design, document and implement the Oracle database implementation and support the inbuilt applications from the backend.
Responsibilities
- Handle responsibilities of data acquisition and access analysis and design on different projects.
- Perform responsibilities of providing best data management practice to application developers and database administrators
- Responsible for designing, maintaining and updating complex data models
- Participate in review of technical documents, Product development action plans and approach.
- Design, Develop and Implement Oracle database architecture in testing environment.
- Created and reviewed design documents with system architects.
- Configure and implement ORACLE RAC, Data Guard for maximum availability and disaster recovery of databases.
- Adhoc technical support to application developers, test team, network administrators, project managers.
- Ensured optimum performance of databases by reviewing and specifying hardware and capacity planning requirements across operating systems.
- Resolves a wide range of issues in imaginative as well as practical ways.
- Lead developers and DBAs through the database, development process.
Environment:
Database: Oracle 10g, Oracle 9i
OS: MS windows 2003 EM64T platform
Other tools: Oracle Enterprise Manager (OEM) Grid Control, Erwin, PL/SQL Developer, Toad, HP SAN, EVA storage,
Confidential, Arlington, Texas June 2008- May 2009
Database Engineer
Siemens Energy & Automation, Inc. is the global leader in mail processing solutions, including innovations in Optical Character Recognition (OCR), postal logistics, image management and control systems. My major role in Siemens is to work with Reading Coding department to develop an application as a standardize product for unattended ORACLE RAC installation, monitoring, maintain and administer databases in development, test, reference, production environments, and develop, support, maintain and test in-house applications.
Responsibilities
- Perform requirements gathering, data mapping, metadata management and databasemodeling.
- Addressed data problems using conceptual, logical, and physical data models.
- Design and implement various high availability solutions for a diverse group of clients running Oracle9i, Oracle10g using Data Guard, RMAN, Oracle Real Application Clusters.
- Provide on call database technical support through all testing phases and general releases of software.
- Participate in Code review, Product development action plans and approach.
- Setup and maintain documentation and standards for Software Verification Document (SVD), Software Design Document (SDD), andSoftware Requirement Specification (SRS), database namingconventions
- Create an automated, enterprise wide installation scripts including Shell scripts, WSH and PL/ SQL for 2 nodes ORACLE RAC and ADD NODE installation.
- Perform SQL and database instance tuning using a wide range of technologies including ADDM, AWR, Statspack,SQLTXPLAIN, extended SQL trace, OEM Performance Manager, and custom scripts.
- Write script to refresh/load data to different schemas in DEV and TEST environments.
- Create and develop test instances from existing templates, migrate instances between environments.
- Perform full database RMANbackup and recovery, data import, export before upgrading the application.
- Develop PL/SQL Stored Procedures, Packages, Functions and Database Triggers to support application.
- Perform database health check including index monitoring, log switch monitoring, parse to execution ratio, space usage, and open cursors problems in different applications modules.
- Perform and update scripts to do failover test, rebuilt of Primary and Standby nodes (recovery).
- Use Oracle Metalink support to resolve different issues related to database servers, security patches.
Environment:
Database: Oracle 10g, Oracle 9i
OS: Red Hat Linux 3.0, MS windows 2003 64 bit EM64T platform
Other tools: Oracle Enterprise Manager (OEM) Grid Control, ER Studio, PL/SQL Developer, Toad, SQL Developer, RequisitePro, Visual Studio Source Safe, SQLTXPLAIN
Confidential, South Lake, Texas May 2007-Dec 2007
Data Architect/ Modeler
Responsibilities
- Spearhead database design, create logical, physical data models, reverse and forward engineering of databases.
- Worked closely with the system architect, data management director, system owner, and end users to develop the requirements and system architecture for new projects to meet the business goals.
- Reporting and tracking database, architecture and application updates and changes using Rational Clear Quest and Clear Case.
- Optimized queries and generated graphical SQL results from Oracle Enterprise Manager Console (OEM), Toad and Grid Agent
- Write shell scripts for automating database processes, triggers and stored procedures for data migration and data load into newly created schemas.
- Manage partitioned and non-partitioned tables and indexes, range partitioning and hash partition of fact tables in star schema while creating data mart.
- Perform SQL performance tuning following SQL trace, optimizer hints, and Explain plan.
- Generate reports of the databases using crystal report.
- Backup database using RMAN level 0, 1, setting up RMAN Repository.
- Data transfer and data load using external tables, flat files and DBLINK between different databases.
- Generate reports of the databases using ORACLE reports and Erwin Data Modeler.
Environment:
Database: Oracle 9i, 10g, MYSQL 4.5
OS: Red Hat Linux 3.0
Other tools: Oracle Enterprise Manager (OEM) Grid Control, Erwin, PL/SQL Developer, Toad, Power Designer, SQL Developer, Clear Quest/Case, HTML,XML, AJAX, SAN EMC, Confluence 2.0
Confidential, June 2007 - Aug 2007
-Sabre's approach to unified identity on the web
Objective: An actionable recommendation on efforts Sabre should put into the establishment of a single identity standard
Responsibilities:
- Research the current actual situation of managing identity and profile management by Sabre.
- Research recent technologies in single identity standards and advancement in web 2.0
- Organize group meeting, documents the deliverables from team mates, conduct interviews and discussions with industry experts.
- Participated in implementing Open ID prototype in IgoUgo website.
- Participated in project presentation.
Confidential, Sep 2005- Dec 2006
System Administrator/DBA support
Responsibilities
- Install, test, troubleshoot and update computer operating systems on UNIX and NT servers.
- Install, Monitor, Upgrade database software's and patches.
- Participated in system architectural design, procurement and sizing.
- Applied operating system patches, application of OS/firmware patches, updates and configuration.
- Supervised overall operations of these facilities including the scheduling of operating hours and crew to accommodate reservation requests and course assignments.
- Hired, trained, and supervised lab technicians.
- Monitoring/tuning Windows Server performance and responding to critical events.
- Configured network of LAN with Client Server architecture, peer-to-peer, and wireless networks.
- Troubleshoot hardware and software errors and malfunctions in computer labs.
- Monitored system performance, security, backups of databases.
Environment:
OS: Windows 2000/XP, Linux,
Database: Oracle 9i, SQL server 2000
Other tools: IIS, Apache, Cold fusion, JDK 1.4, Eclipse, Swing, Servlets, JavaScript, JDBC
M.S in Information System; minor in Business Administration,
B.S. in Information Management; Minor in Business Administration,
Activities/Awards
- Involvement with CTO
- Support to identify the underlying issue related to unexpected crash of specific version of Erwin tool, v. 7.3.7 hampering the day to day activities of Data Architects Company wide. The effort in turn helped Saber to get the more stable version of the tool increasing the productivity of entire architectural work.
- Worked on proof of concept on Sabre approach to SAP MDM (Master data Management) solution to determine if the tool would best fit the Enterprise need.
- Tested the bells and whistles of the Erwin 8 release software on ATSE environment to validate its functionality that give Architects an edge over the older version currently in use.
- Driving Best in Class - GetThere & Data Services Oracle 11G Migration Team
- Driving Best in Class - ATSE Oracle Conversion Team
- Oracle Certified Associate Oracle 10g/11g
- Oracle 10g RAC
- HP Change Management tool
- Automating Software Documentation with ROBODOC - Siemens
- Available on request