Sql Server Data

Resume of: Home Phone 770-***-****

Steven Louis Johnson email: ****@*********.***

SUMMARY OF TECHNICAL SKILLS

Hardware Proficiency: Intel-based systems - desktops and

servers.

Operating Systems: XP/Vista/Windows 7, Windows Server 2003,

Windows Server 2008 R2.

Programming Languages: SQL.

Applications: SQL SERVER 2012 (Microsoft SQL Server

Management Studio v11.0), SQL SERVER 2008

R2 (Microsoft SQL Server Management

Studio v10.0), SQL SERVER 2005 (Microsoft

SQL Server Management Studio v9.0), ADAGE

v4.53, ADAGE v562, OPENROAD WorkBench,

DATASTREAM7i v7.9+, ART v1.7.2, MTECH,

IDERA SQL Diagnostic Manager, BMC Service

Desk Express v10.01, CAMTASIA STUDIO,

DRS, MSOUTLOOK,VERITAS EXEC VIEW.

PROFESSIONAL EXPERIENCE

National Vision LLC, Lawrenceville, GA 08/2012 -

03/2014

Database Administrator base salary $80,090

. Managed the physical data stores for the enterprise. This included

working with data modeling and development teams to put processes and

procedures in place to create new databases, replicate data across

platforms, monitor and manage the databases in production, perform tuning

and analysis, provide space estimates, schedule and configure automated

system tasks, grant data level access privileges and provide consultation

to application development teams on design issues.

. Functioned as the Gatekeeper between application development and the

production environment. This included application installation and

configuration, monitor and implement change control and disaster recovery

preparedness.

. Managed the Change Control processes including validating that all

approval and QC pre-requisites have been met, coordinating/executing the

implementation and rollbacks (if required), communicating and documenting

results.

. Extensive experience in database backup, restoration, recovery,

replication, linked servers, and database maintenance plans.

. Expertise monitoring event viewer, and SQL error logs for software and

hardware related errors.

. Extensive experience in trouble shooting database issues like space

issues, deadlocks, performance and blocking.

. Perform database transaction and security audits. Establish appropriate

end-user database access control levels.

. Performed 24 by 7 DBA responsibilities, including on-call.

Achievements/Recognition

. Planned, practiced, and performed several data migrations from the

company data center to an offsite facility at Internap. Duration was

over several months for multiple Go-Live weekends.

. Successfully planned and implemented a DB migration between a SQL Server

2008 to a SQL Server 2012 server in a production environment, utilizing

the new functionality of AlwaysOn Availability Groups for high available

purposes.

Wayne Farms LLC, Oakwood, GA 07/2006 - 07/2012

Database Administrator base salary $66,800

. Managed the physical data stores for the enterprise. This included

promoting processes and procedures in place to create new databases,

replicate data across platforms, monitor and manage the databases in

production, perform tuning and analysis, provide space estimates,

schedule and configure automated system tasks, grant data level access

privileges and provide consultation to application development teams on

design issues.

. Functioned as the Gatekeeper between application development and the

production environment. This included application installation and

configuration, monitor and implement change control and disaster recovery

preparedness.

. Managed Change Control processes including validating that all approval

and QC pre-requisites have been met, coordinating/executing the

implementation and rollbacks (if required), communicating and documenting

results. Manage and coordinate all ERP application setup and

configuration including installation and security configuration.

. Extensive experience in database backup, restoration, recovery,

replication, linked servers, and database maintenance plans.

. Extensive experience in trouble shooting database issues like space

issues, deadlocks, performance and blocking. Expertise monitoring event

viewer, and SQL error logs for software and hardware related errors.

. Planned and coordinated data migrations between systems SQL Server 2005

to SQL Server 2008. Perform database transaction and security audits.

Establish appropriate end-user database access control levels.

. Performed 24 by 7 DBA responsibilities, including on-call.

. Collaborated with senior DBA to configure the databases in support of the

company wide multiple plant Adage v4.53 OTC & PTPR GO-Live efforts from

2007 through 2011.

Achievements/Recognition

. Planned, practiced, and performed a database conversion required for the

ERP application upgrade - Adage v453 to Adage v562. Planned for 15-20

hours, completed in 12 hours on Go-Live weekend.

. Successfully collaborated with different teams of co-workers in

regards to the Decatur Freezer & several Plant projects. This

entailed installing, updating, and configuring SQL Server 2005,

OpenRoad, Adage v4.51 - 4.53, Adage v5.62- v5.64 and Demand

Planning on a set of servers made available by the IT

Infrastructure team. These tasks were completed ahead of

schedule.

. Promoted twice, after two years as an Application Support

Specialist, I was promoted from the Application Support Team to

the DBA Team as a Database Analyst (Junior DBA ), and then to a

full Database Administrator after an additional two years.

. Consistently and satisfactorily resolved more incidents than any

other member of the Support Development team since my date of

hire. I accomplished this while cross-training with the DBA.

. As part of a team, developed and refined departmental Disaster

Recovery plans and procedures including executing test plans to

ensure business continuity in the event of a disaster,

documentation included; process improvement for all supported

applications.

. Led the effort to develop and refine the on call process now

used by the entire IT department.

AIG AGENCY AUTO, Alpharetta, GA 06/2003 -

06/2006

Product Support Supervisor

base salary $50,000

. Supervised and managed 17 Client Service Representatives on the Technical

Support Help Desk, supporting the external client-facing website, the DRS

rating, and AIG Version Tracker application for 15,000 independent

insurance agents in 38 states.

. Partnered with software developers, providing recommendations regarding

application improvements, release schedule, CD duplication and

distribution. Assisted website and product managers with performance and

defect analysis.

. Managed incident database utilizing SQL -executed queries. Created and

configured weekly and monthly reports displaying product support metrics

which included survey results from the agent, using Crystal Reports.

. Developed and refined departmental documentation including; technical

guides, process improvement, policies and procedures.

Achievements/Recognition

. After seven months as a CSR, I was promoted to Product Support

Supervisor.

. I took the lead in producing and developing multiple task

specific instructional videos for the agent to view off the

website in order to reduce call volume.

. Lastly, I was assigned the departmental lead in the AIG Version

Tracker pilot program which was distributed nation wide.

EDS (Electronic Data Systems), Roswell, GA 07/2000 -

07/2002

Senior Computer Operator - Production Analyst

base salary $39,904

. Supported the CMIS DECSCHEDULER billing application for Verizon wireless

and CenturyTel wireless accounts on VAX and Alpha platforms. Monitored,

scheduled, created, and, edited batch processing jobs which rated and

calculated customer bills from the wireless data collected through the

multiple phases of production. Initiated, monitored, and trouble-shoot

eft import/export of customer data files to clearing house.

. Interacted with customer via ACD and email to provide first/second level

problem determination and resolution on failed critical processes

resolving issue. Provided 24/7 on call customer/application support.

. Coordinated with developers, providing recommendations regarding job

setup, schedule, and DCL command procedures. Assisted system managers

with performance and load balancing of processes on multiple nodes.

. Maintained production databases utilizing Datatrieve -executed rate table

and plan changes, created and configured billing cycle control groups to

verify data, using the ACMS application.

Electro Magnetic Sciences Technologies, Inc., Norcross, GA 12/1985

- 07/2000

Senior Computer Operator

. As part of team effort, developed the help desk function; planned and

implemented procedures for database system to log, track and resolve IT

problems. Assigned work requests to PC Technicians throughout company -

24/7 on-call support. Provided system management functions for

individual and clustered VAX systems - established and monitored user

accounts, provided backup system management. Backed-up and restored data

on multiple servers, using a variety of operating systems (NT, VMS,

etc

EDUCATIONAL BACKGROUND

. Georgia State University, Atlanta, Georgia

Bachelor of Arts - Major in History, minor in Computer Science

. Microsoft Certified Technology Specialist: SQL Server 2005 (MCTS

04/2009)

. Microsoft Certified IT Professional: SQL Server 2005 Database

Administrator (MCITP 03/2010)

Contact this candidate