Occupation:Database Administrator |
Location:Seal Beach, CA |
Education Level:Bachelor |
Will Relocate:YES |
Description
PROFESSIONAL SUMMARY Over 15 years of significant and detailed database administration, data architecture, data warehouse and development experience in SQL Server, Oracle, Informatica, and DB2 environments consulting. Database administrator (DBA) with extensive experience designing, coding, testing and supporting next generation database solutions in MS SQL Server and Oracle. Proficient in an assortment of technologies, including MS SQL Server 2014, Oracle 9i/10g, Access, Sybase, Informatica (ETL), Erwin Data Modeler, T/SQL, SSIS, PLSQL, Idera Tools and LiteSpeed, Stored Procedures, and Batch Processing. DBA skills include: SQL Server 2014 Database Architect/Administrator including AlwaysOn Design and WSFC Cluster Creation Development and SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) Performance Tuning & Capacity Monitoring Data Security, Backup & Recovery Oracle 10g Database Administration SQL Tuning in an Oracle Environment Database-Backed Web Solutions Standby/Failover Administration, High Availability (HA) and Disaster Recovery (DR) * Knowledge of SQL Server Feature Change Data Capture and Change Tracking Experienced in full life cycle development and implementation, project management, gathering business requirements, developing technical and functional specs, designing and implementing data models, integration and migration of data and Extract Transform and Load (ETL) tools. Experienced in building T-SQL/DTS/SSIS processes for data import/export/transformation. Proficient in logical design of data warehouse, construction of the ETL routines and Star Schemas. Experience in creating and executing project work plans. Responsible for assigning individual responsibilities and managing day-to-day aspects of a project. Responsible for reviewing deliverables, before passing to client.
Accomplishments
Highlights:
Keywords
