Senior Database Administrator

Industry:	Information Technology
Occupation:	Database Administrator
Ideal Companies:	Family oriented, job opportunites
Education level:	Master
Will Relocate:	Yes
Location:	Tulsa, OK

1. I suggested merging several systems on to one large database server instead of several smaller database servers. This suggestions saved the company over a hundred thousand dollars that would have been spent on several database servers. Space (land) resource in the data center was also another issue that was resolved with this suggestion. This server is used for all of the vendor packages databases. 2. I help setup and configure the change control application and software. With this installation several reports were requested. This application was setup in third normal form. The reports required several joins with many tables to obtain the require information on these reports. The reports are used on a daily bases by the change control department.

4/2007 - Present

(private)

Individual Contributor

• SQL Server enterprise environment comprised of 60 + servers. The databases range in size from small database to over 1 terabyte databases. This environment is managed by one SQL Server database administrators and a manager. We are responsible for the day-to-day operation, monitoring, configuration and optimizing of these databases. Standards are in place to ensure security, ability to recover from error, and enhance performance of the databases. Required activities are design, implement, maintain, monitor and administer complex databases combined with security, validation checks and space management. Perform daily full and transactional log backups including compressing backups. Backup software including SQL scripts and SQL LiteSpeed. Create DTS/SSIS packages (data import, export and manipulation), tables, store procedures, indexes, roles, jobs, and login accounts. Maintain and create replication (merge, transactional, and snapshot) for SQL Server 2000. Data modeling for new projects. Install and upgrade of MS SQL Server (7.0, 2000, and 2005) including security patches. Lead the DBA group ensuring that the group maintained optimal performance levels, best practices identify and resolve problems associated with database use. Provide assistance as needed for the other DBA. Working environment are Development, Test, Staging and Production systems. Worked closely with developers and business end users to understand and fulfill their business needs.

8/2006 - 5/2007

Tek-System/United States Investigation Service

Individual Contributor

• Lead Database Administrator SQL Server enterprise environment comprised of 65 + servers. The databases range in size from small database to over 11terabyte databases. This environment is managed by three SQL Server database administrators. We are responsible for the day-to-day operation, monitoring, configuration and optimizing of these databases. Standards are in place to ensure security, ability to recover from error, and enhance performance of the databases. Required activities are design, implement, maintain, monitor and administer complex databases combined with security, validation checks and space management. Perform daily full, incremental and transactional log backups including compressing backups. Backup software including SQL scripts, and SQLSqfe, SQL LiteSpeed. Create DTS/SSIS packages (data import, export and manipulation), tables, store procedures, indexes, roles, jobs, and login accounts. Maintain and create replication (merge, transactional, and snapshot) for SQL Server 2000. Data Modeling for new projects. Install and upgrade of MS SQL Server (7.0, 2000, and 2005) including security patches. Lead the DBA group ensuring that the group maintained optimal performance levels, best practices identify and resolve problems associated with database use. Provide assistance as needed for the other DBA. Working environment are Development, Test, Staging and Production systems. Worked closely with developers and business end users to understand and fulfill their business needs. Environments includes OLAP and OLTP, .NET, ASP, Crystal, and Microsoft Reporting Service

6/1999 - 7/2006

Dollar Thrifty Automotive Group

Individual Contributor

• Database Administrator SQL Server enterprise environment comprised of 150 + servers. The databases sizes ranges from small to over 600 gig. This environment is managed by five SQL Server database administrators. We are responsible for the day-to-day operation, monitoring, configuration and optimizing of these databases. We manage change control through development, test and production adhering to a strict change control process that is SOX compliant. Standards are in place to ensure security, ability to recover from error, and enhance performance of the databases. Required activities are design, implement, maintain, monitor and administer complex databases combined with security, validation checks and space management. Perform daily full, incremental and transactional log backups including compressing backups. Backup software including SQL scripts and Embarcadero software. Create DTS/SSIS packages (data import, export and manipulation), tables, store procedures, indexes, roles, jobs, and login accounts. Maintain and create replication (merge, transactional, and snapshot) for SQL Server 2000. Install and upgrade of MS SQL Server (7.0, 2000, and 2005) including security patches. Working environment are Development, Test, Staging and Production systems. Worked closely with developers and business end users to understand and fulfill their business needs. Environments includes OLAP and OLTP, .NET, ASP, Crystal, Microsoft Reporting Service, Informatica, Microsoft Shared Portal. Programmer - Maintain, debug, and write existing/new programs for a 24-hour online system. System analysis and design requirements are performed for technical and user specifications. Existing legacy programs converted using embedded SQL and PL/SQL packages for a new relational database. Assisted new and junior programmers’ with code reviews and training in a new system. Documentation for each new program or code changes was performed. Meeting with users were established to obtain the necessary information for each new project.

2007

Master Degree

Oklahoma State University

• MIS

1999

Bachelor Degree

Langston University

• CIS

Skill	Rating
P&L responsibilities
Presentation
Ecommerce Strategy and digital marketing channels optimization - SEO, SEM, email, affiliates - for high-profile accounts.
Technology Solutions
Sales Support
Software Implementation
Requirements Analysis & Specification
Leadership

sql server, sql server Database Administrator, Database Administrator, Senior DBA