Sr. SQL Server DBA Resume

Title
Sr. SQL Server DBA

Primary Skills
Windows XP, Windows Server 2000/2003, SQL Server 7/2000/2005, T-SQL, Quest LiteSpeed, Toad for SQL, Idera SQLsafe, SAN

Location
US-CA-Los Angeles

Posted
Jun-25-08


Summary
Senior-level SQL Server Database Administrator who offers strong technical, analytical and problem solving skills with expertise in meeting performance, availability and integrity standards. Shown ability to respond to production incidents and solve issues in a timely manner with follow up root cause analysis. Proven track record in gathering
requirements and designing and implementing business solutions. Possess strong organizational and communication skills.

Professional Skills
Windows XP, Windows Server 2000/2003, SQL Server 7/2000/2005, T-SQL, Quest LiteSpeed, Quest Toad for SQL Server, Idera SQLsafe, HP ProLiant, SAN, .NET.

Experience
L.A. Care Health Plan -- Los Angeles, CA 3/08 -- Present
Sr. SQL Server DBA
Install and configure server software and hardware for SQL Server development and production environments. Create and manage database maintenance plans and design and implement backup and disaster recovery plans. Define and enforce database standards, policies, security and documentation. Prepare current database structure and configuration for high-performance through analysis and optimization. Diagnose problems using tools such as SQL Profiler and System Monitor, work with vendors and developers as needed to resolve issues. Monitor database systems performance, capacity and availability. Deploy, configure and monitor complex ETL/SSIS processes. Work on data mapping and conversion, manage disk space, change control and bug fixes.
Environment: Windows Server 2000/2003, SQL Server 2000/2005, Quest Toad for SQL Server XPert, Hybrid SQL SPY, Idera SQL Diagnostic Manager, Idera SQLCheck.

Lennar Corporation -- Los Angeles, CA 8/05 -- 1/08
Senior Database Administrator
Manage over 50 SQL Server instances for a Fortune 150 corporate IT environment. Monitoring of databases, working to maximize availability and tune data performance as needed. Ensure that adequate backup procedures exist for all critical SQL Server instances. Apply latest OS and SQL Server service packs and hot-fixes to ensure maximum security. Worked on building the first data warehousing system utilizing SQL Server 2005. Designed and configured a SQL Server 2005 cluster system to be used by an internal trouble ticket tracking application (HEAT) by more than 300 users. Upgraded number of production servers from SQL Server 2000 to SQL Server 2005. Developed and implemented Disaster Recovery (DR) on production SQL Server 2000 clusters. Environment: Windows Server 2000/2003, SQL Server 2000/2005, .NET, Quest LiteSpeed 4.7, Idera SQLsafe, IBM, HP ProLiant, SAN, DMZ.
eStrategic, Inc. -- Los Angeles, CA 10/02 -- 8/05
Database Manager
Responsible for overall production of the IT department. Performed ad-hoc queries for VP of Sales and Marketing, providing him different industry information. Installed and configured SQL Server environment for migration from MS Access. Scheduled maintenance tasks to monitor overall database performance, as well as design stored procedures and views that generate report files to be distributed on daily basis to clients.
Redesigned entire IT infrastructure, streamlining business processes.
Environment: Windows Server 2000/2003, SQL Server 2000, Database Studios.

eUniverse, Inc. -- Los Angeles, CA 7/01 -- 2/02
SQL Server DBA
Installed and configured Microsoft SQL Server. Developed stored procedures, triggers, indexes and SQL Scripts on an ad-hoc basis. Automated administrative tasks, designed and modified Data Transformation Services (DTS) packages. Performed backups and restores on daily basis. Fine-tuned and maintained large production databases, monitored overall database activities. Extracted and manipulated raw data files. Designed and engineered T-SQL code to archive outdated data from heavy hitting SQL 2K databases. Built and maintained staging server for testing new applications.
Environment: SQL Server 2000, DTS, BCP, Profiler, Windows 2000.

DVD Express -- Hollywood, CA 6/00 -- 5/01
SQL Server DBA
Ran reports for various clients and other departments using scripts written in T-SQL. Managed database users and security. Fine-tuned and maintained large production databases, as well as monitored overall database activities using Profiler. Created and maintained daily backup and restore jobs. Ran reports using SAP R/3 GUI.
Automated existing tasks as well as created new jobs, DTS packages.
Engineered Client/Server applications using Visual Basic 6 and SQL Server 7/2000 databases.
Environment: SQL Server 7/2000, Visual Basic 6, SAP R/3 GUI and Windows NT 4.

Property First, Inc. -- Alhambra, CA 3/99 -- 6/00
Database Analyst
Designed and implemented various scripts, views, triggers and stored procedures.
Built Visual Basic interfaces that executed stored procedures written in MS SQL 7.
Kept maintenance on the existing SQL Server 7 and Access 2000 databases and updated data as needed. Assisted in planning and implementing data migration from Access 2K to SQL Server 7. Performance tuning and monitoring, implementation of backup and recovery. Extracted and parsed raw data files for database import.
Environment: SQL Server 7/2000, Visual Basic 5, T-SQL, DTS, Access 2000 and Windows 2000.






Education
Courses towards MCP & MCDBA Certification 3/02 -- 3/03
New Horizons Computer Learning Centers -- Burbank, CA

MS SQL Server 7 Transact-SQL Programming: Hands-On 12/99
Learning Tree International -- Los Angeles, CA

Diploma in Computer Programming/Database Administration 9/97 -- 5/98
Computer Learning Centers (CLC) -- Los Angeles, CA

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Los Angeles, CA | Resumes in California

View other Sr. SQL Server DBA resumes, Database Administrator resumes