Oracle Developer/DBA Resume Dallas, TX - Hire IT People

SUMMARY

Five years experience in datamodeling, business anddataanalysis, production support, database management, strategic analysis, requirements gathering.
Expertise in Oracle database architecture, Oracle database development, Oracle database administration, database/SQL performance tuning, and Data Warehousing.
Experience in developing Entity - Relationship diagrams and modeling transactional databases and datawarehouse using tools like ERWIN, ER/Studio and Power Designer.
Extensive knowledge of writing SQL queries and PL/SQL program units.
Solid background in data modeling and database design.
Excellent analytical, communication and interpersonal skills.

TECHNICAL SKILLS

Data Modeling Tools: ERWIN, E/R studio, MS Visio

Packages: Oracle Golden Gate, Data Guard, Data Masking pack

Programming Languages: C, C++, COBOL, SQL, PL/SQL, Java,Korn Shell scripting

Databases: Oracle 9i/10g/11g RAC, MySQL 5.x, MS Access, SQL Server

Database Tools: OEM 12c, Data Pump (expdp/impdp), SQL*Plus, SQL*LoaderPL/SQL Developer, TOAD, DBArtisan

Operating Systems: Windows, UNIX, Linux, z/OS

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle Developer/DBA

Responsibilities:

Identified and documented detailed business rules and use cases based on requirements analysis.
Designed and developed database models for the operational data store, data warehouse to support client enterprise Information Management Strategy.
Monitored and tuned Oracle performance using OEM 12c Grid Control.
Managed database security leveraging users, roles, privileges and synonyms.
Partitioned large databases for scalability, management and performance.
Involved in Performance tuning by leveraging oracle explain plan, AWR and TKPROF utilities.
Created data masking mappings to mask the sensitive data between production and test environment
Managed and maintaned large Oracle databases on Linux environment.
Built Oracle RAC databases depicting the physical design.

Confidential

Development DBA

Responsibilities:

Involved in the architechture of databases using agile methodology
Provided guidance to application development teams on the best use of Oracle
Developed PL/SQL stored procedures/packages to simplify bulk updates, bulk inserts and bulk deletes .
Moved data using datapump (expdp/impdp) between production and dev/test databases.
Mentored and trained juniors in Oracle development.
Supported and maintained various development and QA database environments.

Confidential

Software Engineer

Responsibilities:

Worked with senior team members to create a best-fit physicaldatamodel from the logicaldatamodel
Developed routines in Oracle using SQL* Loader to load/integrate data between systems.
Created tables, indexes, views, sequences and other database structures.