Edward M Nicklas Jr
Summary
Experienced and dependable IT professional with a strong background in SQL Server Database Administration. Proficient in all aspects of database management, including performance optimization, availability, architecture, development, capacity management, maintenance, security, disaster recovery planning, and documentation. Skilled in programming languages such as T-SQL, C#, Visual Basic and Visual FoxPro, with a solid foundation in application development including ASP.net web development framework. Committed to delivering high-quality solutions and driving organizational success through efficient database administration and application development practices.
Overview
28
28
years of professional experience
1
1
Certification
Work History
SQL Database Administrator / Lead
IntelliDyne, LLC
11.2011 - Current
- SQL Server Database Administration ( production and development environments ), on Defense Health Agency network.
- Daily and Monthly Administration of approximately 35 SQL Servers, residing within DHA/Defense Health Headquarters (DHHQ), including: Tricare.mil, Health.mil, Office of the Chief Financial Officer (OCFO), and "Terminations, Information Awareness Training, Clearance, and Recertification and Segregation of Duties (TICRS))" databases.
- Troubleshoot, correct and notify related parties of any failure, outage, breach or general SQL Server related issue.
- Monitor database data disk availability and integrity.
- Monitor DoubleTake replication jobs.
- Mitigate database STIG security findings submitted by Security Team to ensure security and compliance.
- Work directly with Security Auditors during Mitigation Efforts to ensure 100% compliance.
- Responsible to install, configure and maintain new SQL Server Database instances ensuring DoD compliance.
- Responsible for database access management.
- Perform installation and upgrades of SQL Server service packs, hotfixes and approved updates.
- Database documentation management.
- Support web developers database requirements.
- Provide ad-hoc livelink data extracts/encrypt via guardian edge.
- Document analysis results and provide performance improvement feedback.
- Lead capacity planning efforts to ensure proper allocation of resources for anticipated growth; made strategic recommendations on hardware and software upgrades based on organizational goals and budget constraints.
- Ensure high availability of databases, plan for disaster recovery and Continuity of Operations (COOP)
- Manage large-scale data migration projects, ensuring accurate and timely transfer of information between systems while minimizing downtime.
- Facilitate system upgrades through diligent testing procedures; ensuring minimal disruption to internal teams during rollout phases.
- Develop comprehensive documentation outlining database administration processes.
- Administer user access levels across databases to protect important data.
- Implement security measures to protect vital business data.
Applications / Database Developer / SQL dba
Vacation.com
10.2006 - 11.2011
- Developed asp.net web applications with C# and VB languages.
- Automated SQL Server tasks by creating DTS packages, stored procedures, scheduled maintenance jobs, T-SQL scripts and messaging alerts.
- Maintained all aspects of SQL Server databases, .net development and system servers.
- Built databases and table structures for web applications.
- Interfaced SalesForce web application to internal corporate database.
- Developed custom tools to automate routine tasks, increasing overall productivity for development.
- Optimized database performance by implementing efficient indexing strategies and query optimizations.
- Proposed system design improvements and enhancements.
- Maintained comprehensive documentation of all database objects, including relationships, dependencies, and usage patterns.
- Identified issues within databases, performed troubleshooting and implemented effective solutions.
Senior Non-Profit Database Programmer / Developer
Merkle Data Technologies, Inc.
07.2005 - 08.2006
- SQL Server database development.
- Application development with asp.net, C# and Visual FoxPro.
- Developed a web based statistical audience code analysis application to automatically select marketing groups for the American Cancer Society.
- Earned a company award for innovation and impact on quality.
- MoneyMaker database application development with Visual FoxPro.
- Seagate Crystal Reports custom reporting services / development.
Director of Programming / Senior Applications Developer
Aristotle International, Inc.
03.2000 - 07.2005
- Web based application development with asp.net, C#.net, VB.net and SQL Server.
- Performed complex data conversions, data validation, data matching and development employing MS SQL Server and MS Visual FoxPro.
- Developed custom applications for organizations including Pepsi, Entergy, Philip Morris and Enron.
- Development of products including Campaign Manager 5.0, PAC Manager 5.0, Constituent Service 5.0 and Grass Roots Manager 5.0.
- Managed a diverse team of programmers, fostering professional growth and skill development in various programming languages.
- Led successful migration projects from legacy systems to modern platforms, minimizing downtime and ensuring seamless transition for end users.
- Monitored programming trends to keep content relevant and up-to-date.
Corporate Planner / Statistician
Telatron Marketing Group, Inc
09.1997 - 03.2000
- Developed, coded and administered a full scale standalone application, named “SEAL”, with Visual Basic connecting to Informix databases which led to the automation of SPSS reporting procedures reducing 75 % of statistical staff requirements.
- Converted conventional reporting methods from Lotus 1-2-3 to SPSS 8.0 statistical software aiding in the automation of hundreds of inbound and outbound Credit Card and Home Equity Loan telemarketing projects.
- Coded, automated and scheduled all SPSS statistical analysis jobs related to daily, weekly, and monthly reports for clients including Travelers Bank, Provident Bank, Mellon Bank, Quicken and Bank of America.
- Created an automated overall call center statistical analysis report (including every project), by time of day and day of week, to predict call volume which resulted in over 80 % more accurate staffing of Telemarketing Sales Representatives which significantly reduced overhead and unnecessary staffing expenses.
- Automated weekly employee payroll reports reflecting telemarketing call performance, per employee, by data mining with Seagate Crystal Reports 7.0.
Education
B.S. - Mathematics & Computer Science
Edinboro University of Pennsylvania
Edinboro, Pennsylvania05.1997
Statistical data mining, data manipulation & reporting
SPSS Incorporated
Chicago, IL01.1998
Engineering
University of Pittsburgh
Pittsburgh, Pennsylvania04.1993
Skills
- SQL Server Expertise
- SQL Server Management Studio
- Database Maintenance and Security
- CompTIA Security Certified
- Active Secret Security Clearance
- ITIL Foundations Certified
- Database Performance Monitoring
- Resource Capacity Planning
- Disaster Recovery Planning
- System Performance Optimization
- Continuity of Operations
- Replication Methodologies
- System Server Configuration
- Technical Documentation
- Database Compliance Audits
Security Clearances
CL - SEC / Clearance Secret Level, 01/25/12 - Present (Active)
Certification
- CompTIA Security+ Certified
- ITIL v4 Foundations
- ITIL v3 Foundations
- 8140 DoD Cyberspace Workforce Framework (DCWF): Database Administrator Certified
Personal Information
Title: SQL Database Administrator / Lead
Professional Overview
Experienced and dependable IT professional specializing in SQL Server database administration, SQL Server database development and application development support.
Timeline
SQL Database Administrator / Lead
IntelliDyne, LLC
11.2011 - Current
Applications / Database Developer / SQL dba
Vacation.com
10.2006 - 11.2011
Senior Non-Profit Database Programmer / Developer
Merkle Data Technologies, Inc.
07.2005 - 08.2006
Director of Programming / Senior Applications Developer
Aristotle International, Inc.
03.2000 - 07.2005
Corporate Planner / Statistician
Telatron Marketing Group, Inc
09.1997 - 03.2000
Statistical data mining, data manipulation & reporting
SPSS Incorporated
Engineering
University of Pittsburgh
B.S. - Mathematics & Computer Science
Edinboro University of Pennsylvania
Similar Profiles
DiAnna HarrisonDiAnna Harrison
Senior Information Technology (IT) Project Manager Network Support Services and Program Risk Manager at IntelliDyne, LLCSenior Information Technology (IT) Project Manager Network Support Services and Program Risk Manager at IntelliDyne, LLC
Alexander FedorovAlexander Fedorov
Information Assurance Security Engineer at IntelliDyne, LLCInformation Assurance Security Engineer at IntelliDyne, LLC
Antonio JonesAntonio Jones
System Administrator/Deskside Support Engineer at IntelliDyne, LLCSystem Administrator/Deskside Support Engineer at IntelliDyne, LLC
EDWARD JOHN CANNONEDWARD JOHN CANNON
Server Engineer, Network Engineer, SQL Database Engineer, Server Administrator, Lead Engineer, Technical Project Manager, •NAS/SAN Administrator at Red HatServer Engineer, Network Engineer, SQL Database Engineer, Server Administrator, Lead Engineer, Technical Project Manager, •NAS/SAN Administrator at Red Hat
SANIA ISASANIA ISA
Lead Oracle/SQL Server Database Administrator at AccentureLead Oracle/SQL Server Database Administrator at Accenture