Database Administrator | Data Architect| Database Developer Resume - Hire IT People

SUMMARY

Information professional specializing in database architecture and database management using primarily Oracle, MS SQL Server and Sybase technologies.
Expertise in data analysis, data modeling and database design, metadata management and repository usage, ETL and database development.
DBA skills include database administration, SQL programming, performance management and tuning, capacity monitoring and database security.
Exceptional communications skills, solid work ethic, acute attention to detail, and driven to succeed.

TECHNICAL SKILLS

Database: Development & Administration, Data Architecture, Data Modeling, Data Migration IT Project Management, Regulatory Compliance, Requirements Gathering, Quality Assurance

Databases: Oracle, MS SQL Server, Sybase, IBM DB2, MS Access Languages PL/SQL, Transact SQL, Unix/Linux shell scripts, Java, XML

OS: Unix, Linux, Windows, DOS

Tools: ERWIN, PowerDesigner, Oracle database utilities, Oracle Enterprise Manager, DBArtisan, Toad, SSIS, SQLDeveloper, SQL Server Management Studio, Oracle Diagnostics Pack, Oracle Tuning Pack, Visual Studio, TFS

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator | Data Architect| Database Developer

Responsibilities:

Managed database design, data transformation and analytics for Treasury applications composed of Cash Management, Payment Processing, Financial Reporting, FX Risk Management, Bank Account Administration, and Liquidity Management. Involved in all phases of database development from needs assessment, data gathering, design, coding, testing, QA, deployment, and support.
Supported Oracle, SQL Server, and Sybase databases.
Conducted database maintenance, database auditing, data analysis, SQL programming, performance tuning, capacity monitoring, db cloning and refresh; and resolved data processing bottlenecks.
Implemented DBMS procedures, jobs monitoring, ETL processing, and data loads.
Set up data governance and code review processes; optimized database code to meet standards.
Supported data requests from business users and addressed audit/risk/SOX compliance concerns.
Assisted in execution of business continuity and disaster recovery plans

Data Architect

Confidential

Responsibilities:

Demonstrated technical leadership in the areas of data definition, modeling, data architecture, logical and physical database design, data quality and database standards.
Designed data solutions for new and re - engineered applications.
Supervised data management, migration, and normalization.
Researched database emerging trends, security issues, and optimization; developed and presented technical solutions to senior management.
Managed database infrastructure engagement with internal stakeholders and external vendors.

Technology: Oracle, SQL Server, Sybase, DB2, PL/SQL, T-SQL, Oracle database utilities (SQL Loader, Data Pump Export and Import), AWR, ADDM, Explain Plan, SQL Trace, SQL Plan Management, bcp utility, SSIS, ERWIN, PowerDesigner

Confidential

Data Architect | Database Developer | Database Administrator

Responsibilities:

Lead technical resource for data modeling, data extraction, data migration, and database development projects.
Worked with business users to gather data requirements.
Administered and maintained Oracle decision support database used in campaign development and lead generation.
Conducted detailed data analysis to develop logical and physical models using Erwin.
Created data integration modules for diverse systems using stored procedures and functions
Created and automated database backup and restore, export files, and ETL routines.
Supported production processes and ad-hoc custom requests from end-users.
Prepared functional specifications and conducted gap analysis for in-house applications.
Resolved technical issues by collaborating with software and hardware vendors.

Technology: Oracle, ERWIN, Unix shell scripts, SQL Loader, PL/SQL programs, and other Oracle database utilities

Confidential

Data Architect | Application DBA

Responsibilities:

Led design and creation of database objects, data flows, and conceptual/logical/physical data models
Collaborated with business analysts and end users to gather system requirements.
Detected, analyzed, and resolved application issues, defects, and integration testing fixes.
Developed inbound and outbound data feeds process to enhance HR Compensation system.
Supported Java programmers on SQL statement tuning and testing.
Established SQL best practices and database release procedure guidelines.

Technology: Oracle, Java, Servlets, JSP, JavaBeans, JDBC, Javascript, PL/SQL, HTML/DHTML, JRun, Oracle database utilities, ERWIN

We provide IT Staff Augmentation Services!

Database Administrator | Data Architect| Database Developer Resume

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship