999 Main Street, Any Town, NY 99999
Home: (999) 999-9999
Cellular: (999) 999-9999
E-mail: email@yahoo.com

Christopher Smith

Career Objectives:

Obtain opportunity to work in a highly professional and competitive environment, which will utilize my knowledge and experience. Further develop my technical skills. Broaden knowledge of the financial industry.

Skills and Knowledge:

• Extensive Physical and Logical data modeling skills.
• Database Transformation Services (Design, Development, Deployment and Administration)
• Installation, configuration, upgrade, optimization, and maintenance of Sybase 12.x and MS
• SQL Server Databases.
• Knowledge and experience in all stages of the System Development Life Cycle, T-SQL.
• Financial and business knowledge.
• Databases: MS SQL Server 2000-2005-2008, Sybase System 12.x, MS Access, Replication Server
• Software: DB Artisan, Erwin, SQL Programmer, Open Client
• OS: UNIX SUN-SOLARIS, HP-UX, Windows 2003

Experience:

11/09 – Present ABC Inc. Any Town, NY
SQL Server DBA

• Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading. Experience in using SSIS tools like Import and Export Wizard, Package Installation, SSIS Package Designer.
• Experience in creating SSIS packages. Experience in DTS Migration and Meta data Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experience in data migration (using tools like DTS, BULK_INSERT, BCP and Replication) between different homogeneous and heterogeneous systems and SQL Server.

11/07 – 10/09 XYZ Corp. Any Town, NY
Sr. SQL Dev & Admin

• Installed SQL Server 2005-2008 and Share Point and applied Service Packs and hot fixes on production, development and backup servers.
• Designed the migration strategy, test plans and scripts to verify data and migrated databases from SQL Server 2000 to SQL Server 2005-2008.
• Planned, designed and implemented application database code objects, such as stored procedures, triggers, cursors, tables, views, joins and statements for applications.
• Implemented techniques like backups, restore, clustering, replication, Log Shipping and DB Mirroring.
• Implemented performance tuning by implementing suitable optimizations and appropriate indexes and keys.
• Used System monitor, event log viewer, SQL profiler, SQL analyzer to monitor and tune the performance of SQL server.
• Designed complex packages for ETL to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, OLE DB, Excel and Access to SQL Server 2005-2008.
• Converted and deployed existing DTS Packages to Integration Service (SSIS) Packages over the Development, Testing and Production environments.
• Used various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data.
• Developed various complex reports in SSRS 2005-2008, Standard Tabular type reports, including Drill Down and Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
• Developed MDX queries and Data Mining Expression (DMX) queries for SSAS 2008 and SSRS 2008.
• Designed complex SSAS cubes with multiple fact measures groups and multiple dimension hierarchies based on the OLAP reporting needs.
• Scheduled jobs, created alerts, notifications with SQL agent and configuring Linked servers for data access between new and old servers.
• Involved in Administration of Share Point Services. Involved in Design and Development of the Share Point server and installed and configured servers in the Share Point farm.
• Installed solution Packages of different Web Parts, Work Flows, Master Pages and Published Info Path forms in to MOSS 2007 server.
• Created Custom Site Definitions, Site Templates, Site Columns, Document Libraries, Lists, List Views, and Content Type.
• Providing on-call support for production systems with rotation basis.

10/05 – 11/07 BCD Inc. Any Town, NY
MS SQL Server DBA

• Actively involved in designing the logical and physical architecture of the Databases.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Created Clustered and Non Clustered Indexes on tables, views, and columns.
• Configured Server for sending automatic mails to the respective people when a SQL Job is failed, log files are grown beyond the predefined limit, or free space of the hard disks fall below the threshold limit.
• Created SQL scripts to pull OLTP data from different Informix servers into the staging database.
• Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor and Windows performance monitor.
• Deployed the databases into the production server clustered environment.
• Optimize Server Performance by Configuring Virtual Memory and Server tasking.
• Monitoring the system bottlenecks – CPU, RAM, Disk IO and Networking using performance counters, alerts.
• Involved in database backup, recovery and restoration.
• Capacity Planning – Analyzed the Database Growth and reported future space requirements.
• Security Management – Handling Roles, Users, Logins and granting the Rights.
• Extensive experience in data guard and replication.
• On-call support during the day on weekdays and rotational on-call support during weekends.

Education:

1980 – 1984 Case Western Reserve University
Major: Bachelor of Science in Computer Science

References

Furnished upon request.
Click to download the SQL Resume Sample One in PDF.

Related Resumes

• CRA Resume Sample One
• CRA Resume Sample Two
• CRA Resume Sample Three
• DBA Resume Sample One
• DBA Resume Sample Two
• DBA Resume Sample Three
• Data Modeler Resume Sample One
• Data Modeler Resume Sample Two
• Data Modeler Resume Sample Three
• Data Warehouse Resume Sample One
• Data Warehouse Resume Sample Two
• Data Warehouse Resume Sample Three
• Data Warehousing Resume Sample One
• Data Warehousing Resume Sample Two
• Data Warehousing Resume Sample Three
• Database Architect Resume Sample One
• Database Architect Resume Sample Two
• Database Architect Resume Sample Three
• Information Architect Resume Sample One
• Information Architect Resume Sample Two
• Information Architect Resume Sample Three
• IT Auditor Resume Sample One
• IT Auditor Resume Sample Two
• IT Auditor Resume Sample Three
• IT Manager Resume Sample One
• IT Manager Resume Sample Two
• IT Manager Resume Sample Three
• IT Project Manager Resume Sample One
• IT Project Manager Resume Sample Two
• IT Project Manager Resume Sample Three
• IT Specialist Resume Sample One
• IT Specialist Resume Sample Two
• IT Specialist Resume Sample Three
• Network Administrator Resume Sample One
• Network Administrator Resume Sample Two
• Network Administrator Resume Sample Three
• Network Specialist Resume Sample One
• Network Specialist Resume Sample Two
• Network Specialist Resume Sample Three
• Program Manager Resume Sample One
• Program Manager Resume Sample Two
• Program Manager Resume Sample Three
• SQL Resume Sample One
• SQL Resume Sample Two
• SQL Resume Sample Three
• System Analyst Resume Sample One
• System Analyst Resume Sample Two
• System Analyst Resume Sample Three