Dennis Johnston

Current

SQL Server DBA at Bradley Arant Boult Cummings LLP

Past

Senior Technician at Bradley Arant Rose & White LLP
PC Technician at Patton & Veigas P.C.

Education

Jefferson State Community College

Connections

32 connections

Industry

Information Technology and Services

Websites

Dennis Johnston’s Summary

Dennis Johnston’s Specialties:

CFM, SQL, T-SQL, MYSQL, IIS, SMS, MSOffice, Web Design, Application Creation, VBA, SharePoint, OpenText DM, InterAction, PHP

Dennis Johnston’s Experience

SQL Server DBA

Bradley Arant Boult Cummings LLP

(Partnership; Law Practice industry)

1999 — Present (10 years )

• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the firm’s databases.
• Responsible for extensive application/SQL monitoring, troubleshooting, tuning, high-availability strategies in a Windows Server 2003 SQL Server 2000/2005 24X7 production environment with multiple SQL servers and data warehouses.
• Ensure that database backups are performed as scheduled, conduct periodic recovery tests, and participate in overall IT organization disaster recovery program.
• Assist/Develop/Implement logical and physical data models.
• Establish and maintain security and integrity controls including backup and disaster recovery strategies.
• Administer, maintain and support InterAction, OpenText DM, Elite, Microsoft Office, Microsoft SMS, Microsoft SharePoint and many custom web applications in a 6 office environment.
• Administer, maintain, support and develop applications using INTAPP integrated appliance.
• Administer, maintain and support the firm’s intranet/internet sites.
• Administer and create SQL 2005 reports based on needs.
• Oversee application design, development and maintenance.
• Programming languages include PHP, MYSQL, T-SQL, CFM, VBA
Senior Technician

Bradley Arant Rose & White LLP

(Partnership; Law Practice industry)

1998 — 1999 (1 year )

• PC support & troubleshooting for over 300 people.
• Network troubleshooting
• Networking environments include Novell 4.11 & 5, NT, Linux
• Setup & support of operating systems including MS Windows 3.1, 95, 98 & NT
• Setup & support of software packages including MS Office 97 & 2000, MS FrontPage 2000, Corel WP 6.1 & 8 & 2000, Interaction 4, PCDOCS, Lexus, Westlaw, ZENworks, SnapShot, GroupWise 5.5
• Setup and support of Compaq desktops (Models DP2000, DP4000 & DP6000) and IBM ThinkPad laptops (Models 380ED, XD, Z & 390E)
PC Technician

Patton & Veigas P.C.

(Legal Services industry)

1996 — 1998 (2 years )

• Maintenance of onsite computers, Microsoft NT Network
• Setup of NT Workstations
• Software Training and Troubleshooting