Tom Powell
Objective | Be a key player in your company’s success by providing technical expertise, extensive experience, and top-notch interpersonal skills. |
Expertise | |
SQL Server | |
TSQL – All aspects of Data Manipulation Language (DML) and Data Definition Language (DDL) | |
SQL Server Administration – General maintenance, performance tuning, backup strategies, scripting, security, SQL Agent, Database Mail, Central Management Servers | |
High Availability Solutions – Log Shipping, Database Mirroring, Database Snapshots, Partitioning, Replication | |
Integration Services (SSIS) data import and export, control of flow, error handling VB & C# scripting, database maintenance tasks | |
Reporting Services (SSRS) report development, delivery options (subscriptions, on-demand, etc.), general administration, security | |
Associated Technologies | |
Visual Studio Database Professional, Red Gate (Schema Compare, Data Compare, SQL Backup, SQL Prompt), SQL Sentry | |
Other Technologies | |
Web Focus (implementation, development, and administration), Cognos (Impromptu, Transformer, PowerPlay), MS Access, VB.Net | |
Roles | |
Database Architect | |
Given explosive growth in customers and locations with requirements for near real time latency and 24/7/365 availability I designed a high-availability solution with stringent reporting requirements and off-site disaster recovery capability. The resulting system includes fail-over clustering, database mirroring, and log-shipping. | |
Database Administrator | |
With over 80 servers and 1200+ databases I was one of two dedicated administrators responsible for all aspects of SQL Server instance and database administration, production support, maintenance of high-availability solutions (Log-Shipping, Database Mirroring, Clustering), and implementing solutions produced by seven development teams. | |
Database Developer | |
I developed an automated system to gather and report on our infrastructure metadata, including database and job locations, database and instance properties, database file growth, etc. Using SSIS to gather the metadata, push database objects, and SSRS for interactive reporting, the system dynamically tracks and supplies required information to the entire 100+ member Information Services team. | |
Instructor | |
I have a demonstrated ability to teach complex technical subjects. I wrote a 100 page textbook to teach a 15 hour class on TSQL For Data Analysts. The original class which graduated 15 students was so successful two more classes were requested by the users. Almost 40 students completed the course able to write basic and medium difficulty TSQL queries. This greatly enhanced their capabilities in business analysis and testing.Multiple presentations at local SQL Server Users Group. | |
Industry Experience
Financial Services | Healthcare |
Retail | Warehouse Fulfillment |
Opinion Research | Telecommunications |
Certifications
Credential | Certification/Version |
Microsoft Certified IT Professional | Database Administrator |
Microsoft Certified Technology Specialist | SQL Server 2005 |
Database Administrator | Microsoft SQL Server 2000 |
Professional | MCP 2.0 – Certified Professional (VB) |
Access to official transcript available on request |
Employment
Dates | Company | Title |
04/2010 – Present | Senior Consultant | |
10/2006 – 3/2010 | ASC IT | Consultant |
10/2003 – 9/2006 | Midlands Choice | Database Administrator/Developer |
05/2002 – 4/2003 | Bass & Associated | Consultant |
08/1998 – 5/2002 | Sogeti – USA | Consultant |
08/1995 – 8/1998 | Guarantee Life Ins. Co. | Actuarial Assistant/Statistical Analyst |
06/1981 – 7/1991 | United States Air Force | Captain |
Education
School | Degree | Date |
Multnomah Bible College | Master of Divinity | 12/1994 |
Embry-Riddle Aeronautical University | Master of Aviation Management | 07/1986 |
Oregon State University | Bachelor of Science in Engineering Physics | 06/1981 |
Looks great Tom! Thanks for sharing!