SUMMARY:

• Database Design/ ER diagrams
• Disaster Recovery Planning
• SSRS and SSIS
• Access 2003, 2007, 2010 (Migrating from 2003 to all higher versions.)
• T SQL UML (Unified Modeling Language) modeling techniques
• Data Recovery and Integrity along while Redgate DBA Schema and Data tools
• Knowledgeable in HTML, CSS
• Cost and Benefits Analysis
• Knowledgeable of Sharepoint 2010 install/configure.
• SSRS Report Writing

TECHNICAL SKILLS:

Platforms: Windows 95/98/NT/2000/XP/Windows 7, Server 2000, 2003,2008, Linux (Red Hat), Oracle 8i,9i,10i, SQL Server 2000, 2005, 2008,2012 and SQL reporting servers and replication.

Networking: TCP/IP, SSH, Ethernet Token Ring, 4 node cluster array

Languages: PL/SQL, HTML, T SQL, CSS, VBA, and C#

Tools: Quest Fog Light and SpotLight Monitoring tools, Norton Firewall, MacAfee/Norton Virus Protection Utility, UML, Microsoft Project, Microsoft Visio, Data Architect, Oracle Developer 6i, Microsoft Office Suite of Applications to include MS Project) FrontPage, AutoCAD LT, Adobe Acrobat, PhotoShop, Symantec for Exchange, Symantec Enterprise, Outlook Exchange 2000, Exchange 2010, SQL 2005 and 2008 reporting services and replication.

PROFESSIONAL EXPERIENCE:

Confidential, Roseville, CA

Database Administrator

Responsibilities:

• Working with SQL Server 2012, SSIS and SSRS, managing and optimizing the health of the SQL environment in both development and production environments. Writing complex queries and stored procedures. Optimizing, tuning queries, and updating database schema. Providing documentation for each report along with a comprehensive data dictionary for all corporate reporting. Creating ETL processes with SSIS that run nightly to update the district's many assessment programs and state reporting. I am also responsible for making small application improvements when applicable.
• Created a development environment that mirrored all aspects of production in environment.
• Migrated older versions of SQL server to 2012.
• Migrated SQL Server database from Windows server 2003 to 2012 VM instances
• Streamlined main daily and weekly tasks via SSIS packages. Not only did this make us more efficient it also enhanced our ability to troubleshoot and respond to issues more rapidly and effectively.

Confidential, Rocklin, CA

BI Analyst

Responsibilities:

• While at Confidential communications, my role as BI Analyst was to provide corporate reporting to the executive team.
• Worked with SQL server 2012, SSIS and SSRS.
• Wrote complex queries and stored procedures.
• Optimized tuning queries and updated database schema.
• Provided report documentation with a comprehensive data dictionary to satisfy corporate requirements.

Confidential, Sacramento, CA

Responsibilities:

• 4+ years of IT and SQL server DBA admin, IT Analyst, and the Design and Development of SQL server 2000, 2005, and 2008 R2 in support of both test and production environments including our various business domains. Our core business was supporting Confidential websites in support of 12 different domains and 50 sub domains while responsible for much of our IT budgeting for both hardware and software need to support our infrastructure.
• Migration from SQL server 2000 to 2005 and 2000/2005 to 2008 by using In - Place upgrade process and as well as side-by-side upgrade process. In 2011, I replicated our production server running SQL 2000 from our data warehouse in Denver to a local server in Sacramento then migrating it to SQL 2005 and 2008 where we ran SSRS.
• Experience in implementing and monitored different types of scenarios such as replication, log shipping on production, QA and dev environments. At Confidential, I managed four primary databases along with three minor-in house databases.
• In-depth understanding of all stages of Software Development Life Cycle (SDLC) The understanding of SDLC was put into play in helping to develop an in-house project management tool using SQL 2005 and MS Access as our front end application. This allowed us to track and report on all outsourced projects. Clients could login and track the status of their projects via the web using SSRS. I played a big role in the development and deployment of this project.
• Having experience and outstanding knowledge of Backup and Recovery procedures. Dexterity in implementing different types of High Availability and Disaster Recovery scenarios like Database, Transactional Replication and Log shipping on Production, QA, and DEV environments.
• Expertise in Database Backup and Recovery procedures by using Native and Litespeed to/from Disk/Legato server tape. Backup and replication took place nightly on all 4 of our major databases done on a 7 day rotation of both full and transaction backups.
• Monitored Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Experience in using Performance Monitor/Profiler to resolve Dead locks/Long running queries. Good experience in data (table) partitioning.
• Optimized, monitored, and performance tuned of SQL Server Systems and databases using DMVs, Activity Monitor, system tables, SQL Profiler, DB Tuning wizard and third party tools.
• Advanced working knowledge of Excel and proficient in pivot tables, data validation, graphs, and reporting.
• Completed educational training in Oracle 9i,,10i and Linux Red Hat 7.