VERNON CLAXTON

***-** *** ******

Rosedale, NY **413

347-***-**** acry3z@r.postjobfree.com

SUMMARY

Seasoned Microsoft Certified database administrator in MCITP and MCTS with 15+ years of IT experience and knowledge of database maintenance/design obtained from positions in banking institutions and financial services. Professional, flexible, creative, service-oriented, offering unique combination of creativity and analytical skill with the ability to assess both vantage points to create cost-effective solutions for internal and external clients. I am a self-starter, diligent problem solver with keen interpersonal skills, Interested in effectively leveraging my skills and experience to make significant contributions to your organization.

Technical Resources

Years of experience using SQL Server Administrations (SSMS, Profiler, Backups), Database design (schemas, database objects, Relational database design (including 1, 2, 3 and 4 forms)) and SQL Coding (Triggers, Stored Procedures, Views, Functions).

Data migration (DTS, SSIS), data mining and warehousing and SSAS (OLAP and OLTP).

Accomplishments in application design, coding and seasoned technical writer (project documentation, user manuals Technical specifications).

Familiar with Oracle 8i, 9i administrative tools (enterprise manager) as well as Oracle developer.

Excellent knowledge of Microsoft Office, with concentration on Excel and Access.

PROFESSIONAL EXPERIENCE

Hansen & Adkins, June 2013 – Current

Database Administrator of transportation services business, duties include:

Administrator of entire SQL Server databases in a multi-server SAN environment including:

oPerformance monitoring, tuning and optimization of entire SQL Server environment.

oUsing said analysis to determine/forecast growth patterns, Memory/CPU requirements

oAlso, using analysis to determine seasonal business trends to better determine capacity planning to prevent a negative impact on database performance.

oCreate standardized polices for the entire SQL environment.

oCreated logins/users and administer credentials/permissions and securables from server level to database level.

oCreated and administered comprehensive backup plan for all SQL servers.

oCreated disaster recovery plan for entire SQL environment.

oWork with development team to insure efficient/effective SQL coding is implemented, deploying only processing that meet standardized business practices.

oExtensive documentation of all processes, procedures and policies.

oTest and evaluate any third party software for possible recommendation to senior management.

oSetup SSRS report server services.

Application/Database was created to manage day-to-day transactions, sales, inventory and weekly-to-yearly sales for monitoring growth, forecasting\directing and accounting purposes.

Handled all managing responsibilities including, corporate budget, Sales, advertising, customer relations, Employee relations (Employed and managed eight employees).

Exploring possibilities of marketing this application/database at the retail level.

KleenCea Corporation, June 2010 – June 2013

IT Administrator\Developer of commercial services business, duties include:

Develop, implement and maintain front-end application with SQL Server 2008 instance including:

oUtilizing SQL Server SSMS, SSRS and SSIS.

oCreating logins, users/groups granting credential, permissions and securables at the server and database levels.

oResponsible for tuning and optimizing SQL Server environment.

Application/Database was created to manage day-to-day transactions, sales, inventory and weekly-to-yearly sales for monitoring growth, forecasting\directing and accounting purposes.

Handled all managing responsibilities including, corporate budget, Sales, advertising, customer relations, Employee relations (Employed and managed eight employees).

VERNON CLAXTON PAGE TWO

Brock Corporation,

Database Developer/Application Designer September 08 – April 2010

Project overview:

Create a SQL Server database and Client application to effectively manage client’s data processing and retrieval of their customer listings and data-mart.

Responsible for extraction and migrating data from pervious database to SQL Server 2005 platform.

Setup a new relational database, included all users, permissions, roles and automated tasks (IE: backups).

Created all new views, triggers and stored procedures to effectively manage data processing and retrieval increasing database effectiveness by 40%

Developed front-end application to manage client data entries with connectivity to SQL database backend, which increased user productivity by 25%.

Provided post project database support, instance tuning and optimizing.

Powers and Thomas,

Database Developer/Database Administrator April 06– August 08

Project overview:

Manage the migration of databases from MS SQL Server 2000 to 2005, including analysis and recommendations on schema and physical relational database design. As well and tuning and optimizing related instances and SQL coding.

Developed new relational data-models forward- engineered (logical and physical schema) using Erwin.

Migrated data from SQL 2000 to 2005.

Created new Triggers, Stored procedures and Views, along with optimizing previous ones. Optimizing database performance by 20%

Responsible for database tuning, securities, permissions, backups and maintenance plans.

Capital One Bank, Lake Success, NY (Formerly, GreenPoint Bank) 1989 – February 2006

Database Administrator/Database Developer/Application Designer

Developed and administrated Microsoft SQL Server 2000 and 2005 databases, including schema and relational design, data conversion and migration, data mining and warehousing, tuning and securities. Secondary duties included Oracle database architecture, schema design, and securities. Architect and administer of over twenty-seven databases and corresponding applications for SQL server 2000 and 2005 that are currently in production

Developed a database/application for the Bank’s Consumer Investment Division, which tracked and data-stored high-level investors’ portfolio activities and correspondences. The application was also used as a static/dynamic reporting tool to identify consumer tendencies and provided the Consumer Investment Division with valuable information for future product recommendations. Critical project task included converting and uploading sensitive loan information (received from clients) into SQL Server database.

Designed an application/data mart to manage the Bank’s education program, which included all employees’ internal and external class scheduling, course completion and grade received. In addition, this application managed the Bank’s Tuition Reimbursement Program, which included calculating tuition reimbursement disbursements on the individual level along with the Bank’s yearly costs for over seven-hundred participants. Creating this Application data mart instead of soliciting an outside vendor resulted in substantial cost savings.

Developed an application/database to manage and service the company’s secondary mortgage portfolio, with assets totaling over 1.8 billion. Increasing customer servicing effectiveness but 30%.

Designed database for a web-based application allowing over fifty-thousand Bank customers nationwide to access certain account information as well as their current mortgage status. Providing one of the first visible products in the company’s web-based initiatives.

Created a database/application for the Human Resources Compensation Division. This database was utilized to identify, compile and formulate calculations based on policies resulting in execution of confidential total compensation letters for over seven thousand employees, including senior management population. Resulting in a reduction of HR payroll by 5%

Composed several detailed technical and user manuals.

Systems Information Technician 1993 – 1997

Network Administration duties included creating and managing domain groups, user permissions rights and policies.

Network administrator for over 100 network accounts

Performed NT systems backups.

Help desk support for over five-hundred NT/Windows users.

Acted as backup to Exchange Administrator.

EDUCATION

BBA – Finance, Computer Information Systems, Pace University, New York NY

Certifications:

MCITP – Database Administrator

MCTS – Implementation and Maintenance

T – SQL Querying.

Software

SQL Server 2000 – 2008 including SSMS, SSIS, SSAS and SSRS, SQL Server Agent, SQL Server Profiler and Database Engine Tuning Advisor.

Oracle 8i, 9i enterprise manager, Oracle studios and Oracle developer.

ERWIN schema development applications.

Microsoft Office, Access, Excel, Word and PowerPoint

Crystal reports, Monarch (data conversion tool)

MEMBERSHIP ACTIVITIES AND INTERESTS

Former member of the national chess association (nationally ranked), Golfer and Sculpturing

Contact this candidate