999 Main Street,
Any Town, NY 99999
(999) 999-9999
email@gmail.com
CHARLES GARCIA
QUALIFICATION SUMMARY
- Senior Database Administrator with over 10 years in the IT industry designing and supporting SQL Server databases.
- Strong foundation in T-SQL programming.
- In-depth knowledge of database performance tuning, including complex query optimization.
- Well-versed in disaster recovery solutions including Database Mirroring, Log Shipping, and Clustering.
- Skilled programmer with experience building service-oriented applications using ASP.NET, C#, XML, XSLS, VB Script, and JavaScript.
- Proficiency in SQL Server Integration Services and Reporting Services.
- Adept in physical and logical storage design.
PROFESSIONAL EXPERIENCE
ABC Inc. Any Town, NY (02/2008 – Present)
SQL Server DBA, Developer
- Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic T-SQL.
- Written Stored Procedures to display the data in front end application.
- Utilized T-SQL on a daily basis in creating customs view for data and business analysis.
- Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
- Optimize existing T-SQL code.
- Analyzed Execution Plans to troubleshoot potential performance issues.
- Utilize Dynamic T-SQL within functions, stored procedures, views, and tables.
- Customized script utilizing expressions and VB scripting to enhance tasks in SSIS.
- Created and maintained SSIS packages designed for replication of data.
- Used the SQL Server Profiler tool to monitor the performance of SQL Server – particularly to analyze the performance of the stored procedures.
- Design high availability solutions and implemented database mirroring and replication for the data security.
- Evaluated the physical model and employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers.
- Assist in Unit Testing on different scopes of Data Architecture.
XYZ Corp. Any Town, NY (01/2009 – Present)
SQL DBA Server Administrator
- Oversaw daily activities for 50 SQL Servers including security management, storage space, backups and restores.
- Created DTS jobs to import and export data from SQL Server to COTS applications.
- Used SQL Profiler to monitor applications using SQL Server.
- Created disaster recovery SOP to restore SQL Server and databases hosted on the server.
- Updated website to include the redirection of web pages and new content.
BCD Inc. Any Town, NY (11/2005 – 02/2008)
Senior SQL Server DBA
- Daily duties included support of 1000+ databases & 50+ instances of SQL Server 2000 and SQL Server 2005.
- Installed & Configured SQL Server 2000-2005-2008 on windows 2000 and 2003 servers and applied service packs and security fixes for all individual servers & Clusters.
- Created SQL clustered environments that is active passive nodes & maintained which supported several applications.
- Worked on upgrade and migration from SQL Server 2000 to SQL Server 2005.
- Managed critical hourly backups using Quest Light Speed, database server and table optimization & restores, high transactional monitoring and optimization for multiple databases.
- SAN Storage configuration for clusters & servers.
- Writing scripts and creating scheduler jobs to automate the tasks.
- Monitored SQL server performance using profiler to find performance issues or deadlocks.
- Linked DB2 & Oracle with MS SQL Server 2000-2005 server.
- Designed and implemented comprehensive backup plan and disaster recovery strategies.
- Worked with SSIS, SSAS, SSRS, and DTS packages.
- Troubleshot database-related issues for clients during implementation, maintenance, upgrade, and migration processes.
- Installed and configured Oracle client on Windows Server.
- Created alerts and jobs for database maintenance.
- Created SQL clustered environment that was active-passive on 2 nodes.
- Responsible for security configuration for shared environments per security policies.
- Proactively used drive space, database size, and backup status for reporting historical and trending information to avoid any production disasters.
EDUCATION
University of Arizona
Degree: Bachelor of Business Administration (December 2001)
Major: Computer Information Systems
CERTIFICATIONS:
Microsoft Certified Technology Specialist (MCTS): SQL Server 2005
LANGUAGES:
ASP.NET 2.0/3.5, C#, T-SQL, XML, VBScript, JavaScript, HTML
DATABASES:
SQL Server 7.0, 2000, 2005
TOOLS:
Visual Studio 2005-2008, SQL Server 2005 Management Studio, Profiler, Surface Area Configuration, Configuration Manager, SQL Server 2000 Enterprise Manager, Database Engine Tuning Advisor, , Windows Performance Monitor, Business Intelligence Development Studio, Red Gate SQL Compare 6, MS Visio, MS Excel, Tortoise SVN, Visual Source Safe, Rally Dev, Re Sharper, Benchmark Factory, Authorize.Net
ENVIRONMENTS:
Windows NT, 95, 98, 2000, XP, 2003
.NET Framework 2.0, 3.5
References
Furnished upon request
Click to download the SQL Resume Sample Two 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