SQL Database Analyst:

Performance and results-driven Information Technology professional with extensive experience in maintaining, managing and servicing systems to ensure accurate and timely IT processing operations.

• Ensures efficient and effective production job processing by implementing expert technical support.
• Provides support to DBAs, programmers, end users and technical teams.
• Develops process and procedure changes to enhance productivity and deliver results on time.
• Executes backup and disaster recovery activities in alignment with organizational needs.

CORE COMPETENCIES:

• Technical Support
• Processing Scheduling / Coordination
• Backup / Disaster Recovery Processes
• Database Administration
• System Monitoring / Management
• Operations Manual Updates
• Team Training / Development
• Issue Escalation /
• Resolution
• Customer Service

TECHNICAL COMPETENCIES:

Hardware:

IBM 3090-180e OS/390 AS/400 -9450 STC 4480 Cartridge

4674 Tape Drives Xerox 4050/4090 STC Impact Printer

Software:

SQL T-SQL PL/SQL Access HTML Word Excel

DOS/VSE Power VM JCL

CERTIFICATIONS :

Oracle Database 10g Administrator

PROFESSIONAL EXPERIENCE:

Confidential,Burbank, California 2005-2011
A Los Angeles County city.

Senior Computer Operator
Facilitated production jobs processing by providing technical support for IBM VM/VSE and Indus Banner systems. Coordinated processing activities in alignment with department schedules, as well as end users, programmers and DBAs request. Implemented schedule and Job Control Language (JCL) changes based on individual requirements. Produced departmental reports, including checks, and disseminated them in a timely fashion. Conducted systems troubleshooting, and deployed remedial actions based on departmental procedures. Monitored the system’s console and met system requests in order to circumvent delays and down times. Managed tape libraries. Provided support to end users, programmers, DBAs and the technical support team as required. Performed required Initial Program Load (IPL).

Confidential,

• Reduced turnaround times, simplified work processes, and collaborated with team members in providing the highest level of customer service.
• Continually strove to improve operations with an emphasis on team work.

Confidential, Covina, California ,1999-2005
A provider of national real estate tax services for residential and commercial loans, including automated online research and certification, tax services, and customized tax outsourcing service programs.

Senior Computer Operator
Maintained and monitored the mainframe system, addressing and resolving issues as they arose. Conducted backup activities daily and weekly to ensure effective in-house and disaster recovery, as well as remote delivery capabilities. Carried out backup procedures using UNIX and NT servers. Developed department job schedules using PCS scheduler. Processed large daily, weekly and monthly batch jobs. Supported user needs, and escalated system and related issues, developing solutions in a timely manner. Produced and managed logs and records. Identified and resolved computer issued error messages. Operated large and small-scale data processing systems, printers, tape drives and disks. Executed after-hours staff, customer and vendor support. Tracked and reported issues related to network servers. Updated operation manuals regarding changes, and monitored servers, escalating identified issues.

• Successfully circumvented system down times, and resolved system problems, developing action plans, and reporting issues to the appropriate person in time.
• Provided exceptional customer service, expeditiously addressing and resolving their issues before the problem affected the department’s reputation.
• Rapidly led new employee training to meet department needs that was recognized by management.

Confidential,Universal City, California 1996-1999
One of the world’s leading media and entertainment companies.

Operation Analyst
Maintained and managed the company’s multi-platform environment that included VM/VSE, MVS and AS-400 systems. Ran and monitored large volume production batch cycles. Determined job and program issues and performed root cause analysis and job re-starts. Conducted Job Control Language (JCL) changes in line with user requests. Executed daily, weekly and monthly backups for in-house and disaster recovery. Generated department reports, and distributed them electronically to local and international customers. Provided staff members, local and international vendors with after-hour support. Met all deadlines and delivered results on time. Performed operation manual updates. Enabled the provision of key service, and created a team culture by cross-training on various systems.

• Resolved 80% of user complaints, and averted system downtime by addressing system issues in a prompt, detailed manner, informing the technical staff before issues caused serious system problems.

Career Note: Additional experience as a Data Analyst and Scheduler for ITT Defense. Details upon request.

EDUCATION:

Bachelor of Science in Information Technology

PROFESSIONAL DEVELOPMENT:

Microsoft SQL Server 2008R2 Database Administrator with Business Intelligence
New Horizons Computer Learning Center Burbank, California (School Certificate Awarded)

Implementing and Maintaining Microsoft SQL Server 2008R2 Database
Managing Database Files, Security and Configuring and Assigning Permissions
Implementing and Maintaining MS SQL 2008 Analysis, Integration and Reporting Services
Writing Queries using T-SQL
Crystal Report 2008, Access 2007
Oracle 10g Administration Training - ABCO Technology Los Angeles, California

Installing and Maintaining Oracle Software through DBCA
Performing and Monitoring Flashback Database
Creating Tables, Tablespaces and Indexes
Using RMAN for Backup/Recovery
Creating, Modifying and Removing Users, Roles and Profiles
Startup and Shutdown Database using EMC and SQL*Plus
Writing SQL Queries