Sql Server Management
Resume:
Cory Paige
Nevada, *****
E-mail: *********@*******.***
OBJECTIVE: To secure a full time position as a SQL Server Database Administrator leading to increased responsibility
and advancement.
EDUCATION: Bachelor of Science in Computer Information Systems, Minnesota State University Moorhead, Moorhead,
Minnesota, December 1999.
Associate of Business in Computer Information Technology, Delgado Community College, New Orleans,
Louisiana, December 1993, Honor Roll: 1991-1992.
COMPUTER
SKILLS: LANGUAGES
Transact-SQL, C++, HTML, SQL Plus 3.1, Delphi 2, Visual Basic 6.0, Visual Basic for Application
SOFTWARE PACKAGES
FileMaker Pro 4.0, Oracle 7.2, Microsoft Access 97/2000, Paradox 7.0, Microsoft SQL Server 6.5/7.0,
Microsoft SQL Server 2000 Enterprise Edition, Oracle Designer 2000, Intersolv Excelerator For Windows,
Microsoft Visual SourceSafe 6.0, Visio2000 Enterprise Edition, Microsoft Visual Basic 6.0, Sybase SQL
Anywhere 7, SQL Anywhere Studio 9.0.1, SourceOffsite Classic Version 3.5.3, ClearQuest Web Version
2003.06.14.567.000, Microsoft SQL Server 2005/2008 Standard/Enterprise/64 bit Editions, Vision Solutions
Replicate1 v4.0.6.1
PLATFORMS
Windows 95, Windows NT Server, Unix 5400, Windows 2000 Advanced Server, Windows 2000
Professional, Windows XP Professional, Windows Server 2003 Enterprise Edition, Windows Server 2003
Enterprise x64 Edition
EXPERIENCE: SQL Server 2005 Database Administrator, Company Confidential, Las Vegas, Nevada
6/2007 - Present
• Activities related to daily database maintenance such as creating backups, editing indexes and performing
installations.
• Provide hardware, software guidance and specifications to the server team when building a server to host
a SQL Server instance.
• Installation of SQL Server 2005 Service Pack.
• Management and monitoring of SQL Server 2005 security.
• Daily operations of maintaining data integrity and SQL 2005 Server disaster recoverability.
• Work with Change Management team and business units for database rollouts.
• Monitoring and evaluation of all database performance tuning.
• Planning and scheduling down time for server maintenance and capacity planning.
• Contributing and establishing database standards, policies and procedures.
• Design and implementation of third party database replication strategies for internal business
requirements.
• Table, stored procedure and view development and deployment using Microsoft SQL Server 2005.
• Provide guidance and specifications on development and design of the corporate data models.
• Use of SQL Server Integration Services to create ETL processes to load the data warehouse.
Database Administrator III, Sierra Health Services, Inc., Las Vegas, Nevada
2/2007 - 6/2007
• Performed activities related to daily maintenance such as creating backups, editing indexes and
performing installations and upgrades.
• Worked with development teams in database planning, creating tables and in the design of the basic
structure of the database using Normalization steps.
• Provided after-hours production support for production database management systems.
• Created and maintained SQL Server 2005 Enterprise Edition Log Shipping process for Disaster Recovery.
Cory Paige 2
• Assisted with management of our Microsoft Clustering Services for SQL Server 2000 Enterprise Edition.
SQL Server 2000 Database Administrator, RELS, Minnetonka, Minnesota
3/2006 - 1/2007
• Logical and physical database design using Normal forms.
• Table, trigger, stored procedure and view development and deployment using Microsoft SQL Server 2000
and 2005.
• Database configuration and installation planning through implementation.
• Maintained, managed and monitored multiple databases and database security.
• Developed database backup and recovery routines.
• Conducted database performance monitoring and tuning.
• Contributed and established database standards, policies and procedures.
• Established infrastructure procedures and guidelines.
• Created, reviewed and produced migration scripts of database objects from development through
production environments.
• Assisted application developers for table, trigger, stored procedure and view development.
• Worked with Configuration Team, team leads, QA and several business units for smooth database
rollouts.
• Provided after-hours production support for production database management systems.
SQL Server 2000 Database Administrator, Fidelity National Foreclosure & Bankruptcy Solutions, Mendota
Heights, Minnesota
10/2003 - 3/2006
• Determined, implemented, and managed database backup and recovery strategies.
• Assisted management with database and resource capacity planning.
• Implemented and enhanced database security using proven methodologies.
• Assisted development staff with the debugging and optimization of SQL queries and Stored Procedures.
• Ongoing database performance tuning and upgrades, including: monitoring and evaluation of all database
patches and service packs.
• Designed and managed database import/export processes used to populate test databases and global Data
Marts.
• Design and implementation of database replication strategies for both internal and DR requirements.
• Transact SQL and Stored Procedure development.
• Created and maintained database ERD diagrams.
• Assisted with database modeling and design functions.
• Hardware implementation and troubleshooting.
• Researched network and database problems and recommended corrective actions.
• 2nd and 3rd level helpdesk support.
• Provided on call support to the IT customers base.
• SQL Server 2000 Enterprise Edition Log Shipping in Disaster Recovery.
SQL Server 2000 Database Administrator, HealthEZ, Bloomington, Minnesota
3/2003 - 10/2003
• Performed data loading via Extract, Transform, Load (ETL) processing.
• Performance tuning, and troubleshooting of SQL 2000 Servers in an Online Transaction Processing
(OLTP) environment.
• Performed migration and execution of Stored Procedures, Triggers, Views and Scripts.
• Provided database security management.
• Designed and transformed logical data models into physical databases (SQL Server) and
normalizing/denormalizing data structures as needed to improve database performance.
• Provided technical support to Management and Application Developers.
• Used Transact-SQL to create Stored Procedures, Triggers, and Views to manipulate data.
• Provided backup and disaster recovery planning for Production and Development SQL 2000 Servers.
• Created DTS packages to aid in ETL type data processing.
• Conducted code reviews of all Stored Procedures, Trigger, Constraints, Indexes, Data Models and
physical SQL Server Databases.
Cory Paige 3
SQL Server 2000 Database Administrator, Meteorlogix, LLC, Minneapolis, Minnesota
3/2000 - 3/2003
• Performed server installations, configurations, and upgrades.
• Performance tuning, and troubleshooting of SQL Servers, NT/2000 Servers in an Online Transaction
Processing (OLTP) environment.
• Database security management.
• Experience with backup and disaster recovery planning.
• Knowledge of data modeling techniques (Normalization).
• Used Rational CASE tool technology to develop logical data models (ERDs).
• Designed and transformed logical data models into physical databases (SQL Server) and
normalized/denormalized data structures as needed to improve database performance.
• With Transact-SQL, created Stored Procedures, Triggers, and Views to manipulate data.
• Experience with SQL Server’s DTS and Replication Services over LAN and WAN communication links.
• Experience with Microsoft Clustering Services for SQL Server 2000 Enterprise Edition.
• Performed data loading via Extract, Transform, Load (ETL) processing.
• Provided technical support to peers and application developers.
• Provided 24/7 on call support in an Online Transaction Processing (OLTP) Environment.
• Performed migration and execution of Stored Procedures, Triggers, Views and Scripts.
Systems Analyst/Programmer, PRACS Institute, Ltd., Fargo, North Dakota
10/1999 - 2/2000
• Worked with Microsoft Access 97 to create file server applications.
• Created client server applications using Microsoft Access 2000 and Microsoft SQL Server 6.5.
• Used ERD modeling techniques to create a data model in a Microsoft Access 97 environment.
• Worked with Microsoft SQL Server 6.5 Enterprise Manager to create stored procedures.
• Worked with ODBC to write queries, create, and maintain tables.
Business Operations Analyst, US Bank Service Center, Inc., Fargo, North Dakota
7/1999 - 10/1999
• Maintained and Developed Visual Basic 6.0 client server applications.
• Provided support for end user applications.
• Assisted with administration of an Oracle 7.2 database.
• Assisted with Microsoft Access 97 development and support.
INTERNSHIPS: Database Developer/Technical Support, Tharaldson Enterprises, Management Information Systems
Department, Fargo, North Dakota
11/1998 - 7/1999
• Used Data Modeling techniques to create physical databases.
• Designed and implemented reports, and queries using Microsoft Access 97 to be used in an Online
Transaction Processing (OLTP) environment.
• Converted all tables, reports, and queries from Paradox 5.0 to Microsoft Access 97.
• Performed interviews and other fact gathering methods.
• Tested, documented, and analyzed current systems.
• Trained users to work with new systems.
• Supported operational applications.
• Recommended new systems and technical solutions to end-users.
• Performance tuning, and troubleshooting of Microsoft Access 97 Databases in an Online Transaction
Processing (OLTP) environment.
REFERENCES: Available upon request.
Contact this candidate