Post Job Free

Resume

Sign in

Microsoft SQL DBA (MCSA - SQL Server 2012)

Location:
Chicago, IL
Salary:
Open/Negotiable
Posted:
November 13, 2014

Contact this candidate

Resume:

VICTOR G. CABILTES

**** *. ***** ***.

Chicago, IL 60645

Tel. 773-***-**** (Home) 773-***-**** (Cell)

Email: acgpq5@r.postjobfree.com

SUMMARY

Computer Information Professional with more than 20 years work experience

in Information Technology specifically in Computer Operations and SQL

Database Administration with a prestigious firm. 10+ years experience in

Microsoft SQL Database Administration and Designing and Implementing

Solutions such as server installation, configuration, implementation,

maintenance,

troubleshooting and performance tuning. Microsoft Certified Solutions

Associate (MCSA) - SQL Server 2012. Responsible and reliable team player

with excellent oral and written communication skills.

PROFESSIONAL EXPERIENCE

PSI Resources LLC, Downers Grove, Illinois

5/2011 - 12/2011,

9/2009 -

1/2011

Microsoft SQL Database Administrator

Contract SQL DBA assigned to Mayer Brown. Mayer Brown is a leading global

law firm with offices in key business centers across the Americas, Asia and

Europe. Provided support and maintenance for the firm's SQL servers,

databases and users. Administered local and remote SQL Servers located in

Chicago, Hong Kong and London consisting of about 60+ Microsoft SQL

Servers. Responsibilities include daily maintenance review, SQL

optimization, disaster recovery planning and testing.

. Monitored daily health and performance of SQL Servers in Chicago,

London and Hong Kong servers.

. Provided support to user requests, database backup and restores,

attend project meetings and troubleshoot SQL database issues.

. Performed SQL Server installations and server upgrades of SQL 2005/SQL

2008.

. Test Disaster Recovery backup procedures with application owners.

. Manage database user requests through Infra Enterprise ticketing

system.

. Created inventory reports on the firm's Hong Kong SQL Servers

detailing hardware and operating system, databases and users in

preparation for the planned upgrade to SQL 2005/SQL 2008. Also

provided server consolidation and server security recommendations.

. Implemented migration plan to move over 200+ databases and consolidate

from 5 SQL servers into 3 new SQL Servers.

. Reviewed software (Idera's SQL Diagnostic Manager V6.1 and SQL Safe

Backup v6.3) and provided written report to management whether the

product is a fit for the company's needs.

. Performed weekend server maintenance - applied latest Microsoft

service packs and hotfixes, run virus scans on servers.

Accenture Ltd., Chicago, Illinois

9/98 - 3/2009

Specialist/Microsoft SQL Database Administrator

Accenture is a global management consulting, technology services and

outsourcing company, with more than 215,000 people serving clients in more

than 120 countries. Provided SQL database administration support for a

complex Microsoft SQL database environment in different stages -

production, test, staging and development. Part of a worldwide DBA team

managing hundreds of servers and database applications which consists of HP

Polyserve SQL environments, clustered and stand alone SQL servers in data

centers located in Chicago (US), Madrid (Spain), Manila (Philippines) and

Bangalore (India).

. Performed database performance tuning - used SQL tools like Profiler,

Perfmon, PSSDiagnostics, SQL Nexus, Performance Analysis by Quest to

troubleshoot software/hardware bottlenecks. Identify long running

queries and provide suggestions or improvements to developers.

. Installation, Maintenance and monitoring of Polyserve instances.

. Perform SQL version upgrades, apply Service Packs and Hotfixes.

. Implement, manage the firm's SQL Server Security standards.

. Provide server security audit reports.

. Create and document database application processes.

. Configuring and troubleshooting remote connections, link servers,

MSDTC.

. Database Maintenance - ensure that database performs optimally.

. Backup and restores of databases.

. Configure and troubleshooting SQL Replication.

. Deploy, maintain and troubleshoot DTS packages.

. Provide on-call support, attend Project Meetings, Bridge calls for

troubleshooting critical issues.

. Train new team members.

Andersen Worldwide (Arthur Andersen LLP), Chicago, Illinois

9/87 - 08/98

Senior Technician

Andersen Worldwide was an umbrella organization formed under Arthur

Andersen which was the largest accounting firm in the U.S. until 2001.

Monitor, analyze, perform server administration, troubleshoot and document

problems on the Arthur Andersen Technology Solutions office automation LAN

environment.

. Monitor Novell file servers and Lotus Notes servers and troubleshoot

software/hardware problems by researching, diagnosing, reviewing

manuals and consulting with peers or vendors.

. Perform daily server backups/restores using Arcserve backup software.

. Provide technical support to users regarding Novell/Lotus

Notes/Windows environment problems.

. Investigate and document network related and system user problems.

. Maintain shift checklist and shift documentation.

. Train new team members.

EDUCATION

Bachelor of Science in Computer Information Systems

DeVry Institute of Technology

CERTIFICATIONS

Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 (September

2014)

Microsoft Certified Professional (MCP): Administering Microsoft SQL Server

2012 Databases

(March 2014)

Microsoft Certified Professional (MCP): Querying Microsoft SQL Server 2012

(August 2014)

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 -

Implementation and Maintenance (February 2014)

Microsoft Certified Technology Specialist (MCTS): SQL Server 2005 -

Implementation and Maintenance (May 2009)

NOTABLE CORPORATE EDUCATION

Polyserve Administration

Microsoft SQL 2005 DBA Training Courses

Microsoft SQL 2000 DBA

Microsoft SQL 7 DBA

Microsoft Windows 2000

Novell 4.11

HARDWARE & SOFTWARE

MS SQL 2005, MS SQL 2000, MS SQL 7.0, Polyserve 3.4, Windows 2003, Windows

2000, Windows 95, Windows NT, Microsoft Office (Word, Excel, PowerPoint),

DOS, ArcServe Backup Software, Novell 4.11, Lotus Notes

REFERENCES

Available upon request



Contact this candidate