Manager Sql Server
Resume:
ROBERT COCOM
DATABASE ADMINISTRATOR
PO BOX **
EL CAJON, CA 92022
*****@***.***
Solutions-oriented professional with education, related experience and drive to achieve
QUALIFICATIONS PROFILE
organizational objectives.
• Experience designing and architecting data warehouses.
• Excellent understanding of RDBMS (relationship database management systems)
• Excellent written and verbal communications skills; comfortable with documentation
and presentation requirements.
• Well organized and able to prioritize multiple projects effectively
• Talent for problem-solving and troubleshooting skills
• Strong project planning, research, and implementation abilities
• Ability to plan technical projects; researching, coordinating bids, and negotiating with
vendors.
LANGUAGE & APPLICATIONS:
TECHNICAL KNOWLEDGE
• SQL Server 2000/2005/2008, Oracle 9/10, PostgreSQL 8.3, SQL Server Integration
Services (SSIS), SQL Server Reporting Services (SSRS), Crystal Reports, Visual Studio
2008 (.NET), Microsoft Office 2007, Windows Server 2008, Linux, and Macintosh OS
X, Active Directory
DATABASE ADMINISTRATOR
EXPERIENCE
San Diego Metropolitan Transportation San Diego, CA 10/2007-7/2009
Design and developed enterprise data warehouse and business unit data marts.
Administers, maintains, develop and implement policies and procedures for ensuring the
security and integrity of the company’s Oracle and SQL Server databases. Implemented
data models, database designs and data access policies and procedures.
• Developed data warehouse for analytical applications and reporting tools for various
business systems throughout the organization.
• Design and develop Extract Transformation Load solutions for various data
transformation needs including inbound and outbound data sources to support data
marts, data warehouses, production, and development systems.
• Developed custom language runtime database functions and procedures using C#.
• Analyzes the organization's database needs and develops a long-term strategy for data
storage.
• Resolves database performance issues, database capacity issues, replication, and other
distributed data issues.
DATABASE ANALYST
SMS.ac San Diego, CA 5/2006-9/2007
Responsible for the ongoing operation of the company's reporting database systems,
investigates database tools and products, and provides weekly training to staff for
successful design, implementation, and administration of Microsoft SQL Server 2005
databases and reporting tools.
• Work with Business Analysts to refine and develop business queries using advanced
analytics.
• Provided guidance in logical and physical design, defining and/or updating reporting
database tables, triggers, indexes, constraints, and stored procedures.
• Developed, tested, and implemented appropriate backup and recovery procedures.
1
ROBERT COCOM
DATABASE ADMINISTRATOR
PO BOX 10
EL CAJON, CA 92022
*****@***.***
• Conducting periodic tuning of the databases, capturing and reporting database usage
statistics as appropriate, regularly monitoring space usage, and providing technical
support.
• Established and maintained security and job schedules for reporting requirements.
DATABASE ANALYST
Seacon-Brantner, San Diego, CA 05/2005-05/2006
Organized business requirements, preparation of technical design, specifications, and
other documents for reporting databases.
• Implements data models and database designs, data access and table maintenance codes;
resolves database performance issues, database capacity issues, replication, and other
distributed data issues.
• Managed complex manufacturing projects and maintained vendor/customer relations
without supervision.
DATABASE ADMINISTRATOR
Various Employment Staffing Agencies San Diego, CA 01/2003-05/2005
Performed tasks related to the full life-cycle development of databases for internal and
external client use. Tasks include planning, analyzing requirements, designing solutions,
developing code and testing software. Responsible for the administration of existing
databases and the analysis, design, and creation of new databases
• Data modeling, database optimization, understanding and implementation of schemas,
and the ability to interpret and write complex SQL queries.
• Establish standards and best practices for SQL and developed system documentation.
UNIVERSITY OF CALIFORNIA SAN DIEGO
EDUCATION
San Diego, CA Information Technology and Software Engineering, 2008
Lessons completed:
• Introduction to Data Modeling and Data Warehouse Design
• Oracle Performance Tuning and Administration
• Conceptual understanding of database architecture and its components.
• Configure and administer relational databases using Oracle.
• Performance monitoring, database security, user management, and backup/recovery
techniques.
ITT TECHNICAL INSTITUTE
San Diego, CA Bachelor of Science in Communication and Electronic Engineering, 2005
ITT TECHNICAL INSTITUTE
San Diego, CA Associate of Computer Engineering and Electronic Technology, 2003
2
ROBERT COCOM
DATABASE ADMINISTRATOR
PO BOX 10
EL CAJON, CA 92022
*****@***.***
REFERENCES JOHN WISSENBERG
Data Analysts, SDMTS San Diego, CA
CORTNEY RAY
Network Operations Manager, SMS.ac San Diego, CA
**********@*****.***
MATTHEW MARKSBERRY
Analytics Framework Manager, SMS.ac San Diego, CA
***********@****.***.**
JEFF HARNS
Software Development Manager, SDMTS San Diego, CA
****.*****@*****.***
DANIEL TRENT
Operations Manager, SDMTS San Diego, CA
******.*****@*****.***
3
Contact this candidate