David B. Smith
Meriden,United States
Summary
Multifaceted technical career with a track record of innovation and success. Technically sophisticated database administrator with solid history of integrating and upgrading server and database systems. Broad knowledge and success in a software development environment. Skilled trainer and project leader; able to direct multiple tasks effectively and master innovative software and tools.
Overview
41
41
years of professional experience
Work History
Lead Database Specialist
VOYA FINANCIAL
Windsor, Connecticut
01.2015 - Current
- Monitor database KPI’s to identify consumption patterns and/or opportunities for improvement
- Gather infrastructure data to support potential cost reduction or avoidance situations
- Create strategies for implementing new features, versions, and upgrades
- Develop and update the current and future Oracle platform roadmap
- Ensure Oracle platform database configurations and best practices meet corporate standards
- Monitor company adherence to service level and support agreements
- Conserved $100K by reconfiguring storage space during green dollar savings initiative
- Provided Exadata patching after vendor Platinum Service proved unsuccessful
Lead Systems Engineer
VOYA FINANCIAL
Windsor, Connecticut
01.2013 - 01.2015
- Analyzed critical and chronic root causes and generated solutions as Tier 3 operations support team member
- Coached customers through routine process automations, adhering to software development lifecycle standards
- Automated the quarterly patching of Oracle databases for use with either HP Server Automation, or in standalone mode
- Enhanced the monthly server security scan process
Senior Database Specialist
VOYA FINANCIAL
Windsor, Connecticut
01.2006 - 01.2013
- Analyze server and database performance statistics to identify bottlenecks for applications
- Establish baseline KPI’s for alerting and monitoring
- Troubleshoot SQL performance of business processes as required
- Implement data model design into the database
- Administered 90-server, 630-database Oracle enterprise environment
- Orchestrated new database installations, server and database mergers, and system decommissions
- Delivered Tier 2 and Tier 3 problem-solving customer support
- Identified and resolved server and database performance, capacity, and configuration issues
- Investigated escalated outage/alert root causes and stabilized database with change-control standardized processes
- Upgraded and patched software and databases, boosted database automation with redesigned or new functions, and collaborated with cross-functional technical teams
- Saved $400K in customer software application costs by developing a process to remove separately-licensed Oracle options
- Reduced Oracle backup storage usage by 242TB and saved $69K by reconciling total Oracle storage
- Satisfied corporate security requirements by designing novel, non-vendor, and Oracle platform-patching process focused on binary and database updates
- Shortened security scan process duration from one week to two days with process improvements
- Strengthened database uniformity and ensured best practices with upgraded standard operating procedures (SOPs)
- Query analysis, optimization, and performance tuning
Lead System Specialist/Database Administrator
TRAVELERS
Hartford, Connecticut
01.2000 - 01.2006
- Spearheaded auditing, security, source code, backup, and server configuration database projects
- Identified potential security, disaster recovery, availability, operational readiness, and manageability outcomes for new technology
- Streamlined routine database administrative functions with source code focused on enterprise-wide directives
- Designed and implemented software automations with PERL programming language, PVCS version control, and Source Control Management (SCM)
- Developed replicated database process with Business Continuous Volumes (BCV) to reduce time needed to correct outages within a single production server, disk array, file system, Oracle database, or server network connection
- Oversaw security exposure mitigation for Oracle
Application Consultant II
KRONOS INCORPORATED
Chelmsford, MA
01.1997 - 01.2000
- Manage SQL Server, Oracle, and Windows based labor management software implementations throughout Connecticut, Southern Massachusetts, and Rhode Island
- Provide technical support to the DBA staff with regards to database creation, security, performance and tuning, and client connectivity
- Analyze current payroll policies and derive the automated equivalent
- Design and develop customer requested application enhancements
- Establish customer alliances for on-going support
- Implemented hand scanner for City of Stamford employee time entry
Product Development Intern
MCI TELECOMMUNICATIONS CORPORATION
Edison, NJ
01.1995 - 01.1996
- Development projects include a specialized conversion macro of Word documents for MCI’s fax messaging system, customize the installation of the network messaging scheduler and workstation components, and update fax communication scripts to incorporate new transmission technology
- Conversion macro was implemented at Bear Stearns
Financial Management Specialist – Systems Monitor
UNITED STATES AIR FORCE
01.1984 - 01.1992
- Ensure accuracy of departmental subsystems interfacing with the base-level Accounting & Finance Office
- Perform daily, monthly, and yearly accountability processing
- Systems administration responsibilities include year-end conversion of fiscal data, coordinating release and patch updates, generate and evaluate fund status reports, identify data entry and out of balance conditions for correction, and provide Tier-2 level technical support for finance personnel
- Implemented workforce management system 2 months ahead of schedule
- Reduced fiscal year-end conversion timing from 2 weeks to 3 days by streamlining the month end validations performed by the various areas
Education
Bachelor of Science - Computer Science, Management Information Systems
Central Connecticut State University
New Britain, ConnecticutSkills
- Database Administration
- Systems Launch / Implementation
- Full-Stack Software Management
- Client Relationship Management
- Data Analysis/Interpretation
- Backup and Recovery Strategies
- Problem Resolution / Troubleshooting
- User Training and Support
- Exadata
- Linux
- AIX
- HP-UX
- Solaris
- Oracle Enterprise Manager 13c
- Oracle Enterprise Manager 12c
- Real Application Clusters
- Flashback
- Automatic Shared Memory Management
- Data Guard
- Grid Control
- Recovery Manager
- Automatic Storage Manager
- Zero Data Loss Recovery Appliance
- Perl
- Tivoli Storage Manager
- Tivoli Workload Scheduler
- Netbackup
Timeline
Lead Database Specialist
VOYA FINANCIAL
01.2015 - Current
Lead Systems Engineer
VOYA FINANCIAL
01.2013 - 01.2015
Senior Database Specialist
VOYA FINANCIAL
01.2006 - 01.2013
Lead System Specialist/Database Administrator
TRAVELERS
01.2000 - 01.2006
Application Consultant II
KRONOS INCORPORATED
01.1997 - 01.2000
Product Development Intern
MCI TELECOMMUNICATIONS CORPORATION
01.1995 - 01.1996
Financial Management Specialist – Systems Monitor
UNITED STATES AIR FORCE
01.1984 - 01.1992
Bachelor of Science - Computer Science, Management Information Systems
Central Connecticut State University
Similar Profiles
Grant BrandhoffGrant Brandhoff
Associate Financial Advisor at FourWord Financial and Voya FinancialAssociate Financial Advisor at FourWord Financial and Voya Financial
Michael SmithMichael Smith
Vice President/Product Director at Voya Financial/ING/Aetna Financial ServicesVice President/Product Director at Voya Financial/ING/Aetna Financial Services
Jennifer BolesJennifer Boles
ERISA Coordinator / Regulatory Services at Voya Financial/OneAmerica FinancialERISA Coordinator / Regulatory Services at Voya Financial/OneAmerica Financial
Amy GrindstaffAmy Grindstaff
Trade Review Principal at Voya FinancialTrade Review Principal at Voya Financial
Joshua RamirezJoshua Ramirez
Class A CDL Driver at TMCClass A CDL Driver at TMC