Database Systems Developer Resume
Database Systems Developer using SQL Server Management
- Competent, analytical candidate with experience in the design, development, and management of SQL Server. Possesses understanding of data modeling and ER design.
- Quick learner with more than 4 years of professional experience in an IT environment with the County.
- Great writing skills and ability to listen
TECHNICAL COMPETENCIES
Database Management Skills: Microsoft SQL Server 2008, XML, Query Performance Tuning, T-SQL, Data Flows, DB Securityand Encryption, Scripting & Custom Components, Reporting Services, Package Deployment/Management, SQL Server 2008 Implementation, Error Logging & Handling, Advanced SQL Querying & Programming
Tools: SQL Server Management Studio, Business Intelligence Development Studio
Software/Hardware: MS SQL Server 2008 Integration Services (SSIS), MS SQL Server 2008 Reporting Services (SSRS)
Networking: Setting up networks
EDUCATION & TRAINING
Confidential, 06/2012
SQL Master’s Program
The SetFocus SQL Server Master’s Program is an intensive, hands–on, project oriented program where participants gain knowledge and valuable experience putting the SQL Server skill set to use in a simulated work environment.
Advanced SQL Programming
- Created numerous simple to complex queries involving self joins, correlated sub queries, CTE’s and XML techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
SQL Server 2008 Database Design and Implementation
- Analyzed the business requirements and systematically designed a database for an online-movie (DVD/Blu-Ray) rental company working as a team. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using XML and SSIS.
- Created various reports according to the business requirements for the movie rental company in a team-oriented environment. Individually authored, installed, deployed and managed reports using SSRS for a library database.
- Individually designed a bank application according to business requirements, and implemented robust stored procedures, functions, and triggers to implement required functionalities.
- Created an ETL solution that reads Product, Vendor, and Order data from. CSV files on a network share into a SQL Server database. Solution validated incoming data and performed notifications when jobs complete. The order data thus loaded into SQL Server and was used to generate reports using the new SSRS 2008 reporting functionality (including the Tablix control). Reports were set up
for automatic delivery based on standard report subscriptions.
Professional Work History
Confidential,Palo Pinto County 11/2008-Present
Palo Pinto, TX
- Created Database with SQL 2008 R2
- Created Tables
- Created Stored Procedures
- Created View
- Use Database Engine Tuning Advisor on queries etc
- Use SSRS for monthly report
- Setup new computers, install software, install printers, and scanners
- Trouble shoot network problems
Confidential,Bennett’s Office Supply 04/2007-11/2008
Mineral Wells, TX
- Trouble shoot and repair copiers and printers
- Install and setup new copiers and printers
Confidential,Internet Marketing 08/2004-04/2007
Mineral Wells, TX
- Setup and install computers, software, run virus scans
- Install networks in business and houses
Confidential,Perry Equipment 08/2000-10/2001
Mineral Wells, TX
- Setup blend line machines
- Run blend line machines