Senior Database Administrator Resume Commerce, CA - Hire IT People

SUMMARY

Database administrator (DBA) with extensive experience designing, coding, testing and supporting next - generation database solutions in MS SQL, DB2-LUW and Informix enterprise server environments.

PROFESSIONAL EXPERIENCE

Confidential, Commerce, CA

Senior Database Administrator

Responsibilities:

MS SQL database administration on SQL SERVER 2003, 2005, 2008, 2012 and 2014.
MS SQL installing, configuring, monitoring and troubleshooting Windows Cluster (colocation), SQL Cluster, Always on Availability Group, Availability Group Listener, Log Shipping, and Mirroring.
In-depth knowledge of MS T-SQL development including stored procedures, functions and queries.
Performance tuning & capacity monitoring, software installation, data security, backup & recovery, standby/failover administration, SQL turning environment. Troubleshooting SQL jobs in production, QA, and development.
Design standards related to database administration, performance evaluation and technologies used for maintenance and data replication. Involved in architecting large SQL Server database projects, compiling business requirements and providing additional engineering and end-user support.
Installed and supported Reporting Services environment (SSRS).
Installed and supported developing data flow processes using SQL Server Integration Services (SSIS).
Work extensively with users, able to translate requirements into highly specified, logical and innovative solutions for complex problems.
Recommends and advocates for additional data and/or services needed to address key business issues related to process or solutions design.
Convert Informix, Legacy Mainframe and DB2-UDB databases data to MS-SQL database.
Support data-integration project for financial services dat consolidated information from accounting application.
Developed and tested storage strategies and disaster-recovery plan for company’s operational database, delivering solution dat guaranteed recovery performance and high availability.
Write MS SQL, UNIX Shell and AWK scripts to support daily operations.
Provided DB2 LUW and Informix database administration.
Provide 24 by 7 technical on call support.
Upgrade current systems to SQL 2008, including a filestream setup
Worked on both relational and online analytic processing components using Microsoft SQL & OLAP Servers included assessing the suitability of using MS SQL Server OLAP Services as a reporting platform for warehousing application.
Supported OLTP/OLAP and Data Warehousing in Microsoft SQL Server.
Initiated multiple SQL Server upgrades, first from 2000 to 2005, then to SQL Server 2008R2, including engineering and orchestrating hardware and other infrastructure upgrades.
Trained in service level agreements (SLA)

Confidential, Culver City, CA

Database Administrator

Responsibilities:

Informix database administration in Informix products. Responsibilities: Installation, database migration, database schema design, logical design, physical design, data archiving, server performance tuning, maintenance, troubleshooting and upgrading of the databases, procedures, triggers, tables and user documentation.
Wrote Shell scripts to ease the daily operation, supported the content production team by moving content to development and testing environments. Intensive deadline driven, teamwork environment. Java, Solaris, Weblogic, Informix, Window Media, proprietary content management system.

Confidential, Commerce, CA

System Developer/DBA

Responsibilities:

Developed customer price quotation support character base system using Informix 4gl.
Developed Web based version of customer price quotation using Java language, allowing customers to view and print the invoice from the internet.
Informix 4gl Forms and Reports Development.
Database administration on Informix Dynamic Server included database software installation, performance tuning & capacity monitoring, data security, backup & recovery and standby/failover administration.
Developed and tested storage strategies and disaster-recovery plan for company’s operational database, delivering solution dat guaranteed recovery performance and high availability.
Write & analysis sophisticated financial reports for marketing, finance and accounting departments.
Convert database data from Informix to Oracle.
Enhanced end users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.
Write UNIX an AWK scripts to ease the daily operation.

Confidential, Long Beach, CA

Database Administrator consultant

Responsibilities:

Informix database administration in Informix products. Responsibilities: Installation, database migration, database schema design, logical design, physical design, data archiving, server performance tuning, maintenance, troubleshooting and upgrading of the databases, procedures, triggers, tables and user documentation.
Wrote UNIX Shell and AWK scripts to ease the daily operation.

We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

Commerce, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship