999 MAIN STREET• ANY TOWN, NY 99999
PHONE (999) 999-9999• E-MAIL EMAIL@GMAIL.COM
James Thomas
OBJECTIVE
To join a strong team requiring an innovator who is self-motivated and focused and who can guide, develop and deploy data driven and geopolitical strategies using spatially aware relational database management systems.
KNOWLEDGE BASE & SKILL SET
- MS SQL 2000, 2005 Developer (highly proficient)
- T-SQL including stored procs, udfs, views, query optimization (highly proficient)
- PostgreSQL, PL SQL (experienced) & Post GIS (functional)
- My SQL (experienced)
- MS Access (proficient)
- PitneyBowes MapInfo products (highly proficient)
- Data Modeling, Analysis & QA (i.e. CRM, Reporting, cubing, data audit, db modeling, etc) (proficient) • MS SQL Server Integration Services (highly proficient)
- MS SQL Server Reporting Services (functional)
- MS SQL DBA Responsibility (security, network, etc) functional
- PHP (functional)
- HTML, CSS, Java Script, (functional to experienced)
- Other: Office products, Eclipse, Photo shop, Gimp, Open Office, FTP, Batch, PG Admin III, Crystal Reports, My SQL Workbench, Unix, Windows (experienced and proficient)
RELEVANT EXPERIENCE
ABC Inc.
SQL Database Analyst (2 years)
- Created and executed SQL statements in both SQL production and development environments.
- Provided SQL Support to front end users.
- Resolved issues within production database using T-SQL queries.
- Analyzed FTP share and provided information for senior manager.
- Created SQL instances and databases as needed.
- Executed daily batch processes, and researched file share for a duplication project.
- Worked with Data Analyst to write user-interface.
- Accountable for being the Data Analyst and Sr. DBA backup when they were unavailable or out of the office.
XYZ Corp.
SQL Server Development and Administration (2 years)
- Performed DBA function to manage implement database security, and upgrade to SQL Server 2005.
- Worked on SQL Server 7.0 to SQL 2000-2005 migration for production environment.
- Responsible for running and maintaining in-house and customer SQL Servers (100+ customer sites).
- Design, write and implement application database code objects, such as tables, views, functions, store procedures for different applications.
- Developed SQL paging system for different issues such as drive space, deadlocks, SQL Job failure, SQL Job Stuck, expensive queries.
- Tune existing store procedures by putting indexes, and improving complex queries performance by using better logic with less reads and CPU usage.
- Write SISS and upgrade DTS packages for data analysis and extraction.
BCD Inc.
SQL Server Developer (4 years)
- Worked with the project manager and project sponsor to architect and design applications. Wrote specs and blueprint screens. Designed and created database schemas, stored procedures, triggers and functions. Created various reports in SSRS called from .NET front-end.
- Implemented, maintained, and documented policies, procedures and standards to ensure security and integrity of test and production data.
- Utilized SSIS to manage and create ETLs to transfer data from various sources.
- Maintained and translated reports from Crystal Reports into SSRS.
- Developed SSIS packages to transform data from SQL 2000 to MS SQL 2005.
- Developed and maintained a backup and recovery strategy for all databases.
- Created documentation for DRP (Disaster Recovery Process).
Certifications, Classes and Notable Accomplishments:
Certified MS SQL Server 2005.
General:
- Extremely creative in problem-solving with strong analytical abilities and a keen eye for problem mitigation.
- Strong command of communication with a focus on information aesthetics and audience access—verbal, written and visual.
- Rapid learner. A penchant to grasp complicated concepts quickly.
- Innovative, self-starter who enjoys leading others to successful execution of objectives.
EDUCATION
- University of Southern California
- M.S. Computer Science
INTERESTS:
Motor Sports, Music and Reading.
Click to download the SQL Resume Sample Three 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