Greater Cleveland
Accomplished IT professional with expertise in database architecture and administration, system design integration, and application security in the financial services industry. Managed the data infrastructure through expansive growth, acquisitions, platform migrations and cloud integration. Adept in collaborating with technical teams, QA, project management, and product owners to ensure seamless data integration aligned with business objectives. Skilled in systems administration and software development. Ready to take on new challenges to allow growth and development, with a passion for seeking innovative solutions using a variety of technologies, from the web, across the desktop to the datacenter. Functional Expertise • Database Administration and Architecture • Data Reporting and Business Intelligence • Data Governance, Security and Auditing • Server Administration • Application Development • DevOps Integration • High Availability and Business Continuity Strategy Technologies / Tools • MS SQL Server, Oracle, PostgreSQL • Synapse, NoSQL • SSAS, SSRS, PowerBI, PowerApps • Collibra, Idera CM, Clarip, Varonis • Windows, SELinux, OracleLinux • VB/VBA/VB.NET/C# ASP/ASP.NET PHP • TFS, git, CVS, SVN, Azure DevOps • SQL AlwaysOn, Azure SQL Database, Transactional Replication Solutions
I am an accomplished IT professional with expertise in database architecture and administration, system design integration, and application security in the financial services industry. I am currently seeking new opportunities. Contact me via LinkedIn.
Established direction for future database platform and migration options, documenting and eliminating technical debt in the database estate, and collaborated with application development, data warehousing and reporting teams on system readiness for future state architecture. • Provided roadmap for migration to hybrid and cloud native operational models. Improved data availability and scalability and reduced on-sight overhead and cost. • Led a data retention review and cleanup initiative eliminating 150+ TB of stale or redundant data and reduced the SQL database storage footprint by 18%. • Designed a distributed high-availability architecture for SQL server databases spanning multiple datacenters in US and UK to meet business and legal requirements. • Led a discovery of SQL database interdependencies, eliminating 1,500+ cross-database references. • Eliminated or consolidated 4,500+ legacy reports to current preferred platforms. • Identified, removed or anonymized customer personal identifying information (PII) in non-production databases. Established policies and processes to clean data of customer PII when being pulled into debugging or reporting environments.
Led teams of up to 18 Database Administrators (DBA) across the US and UK, managing 500+ database servers in the US, UK, and EU, including health, patching, migrations, performance monitoring, and troubleshooting with development or reporting teams. Collaborated with audit, compliance, IT, and business units to support legal data storage requirements and strengthen the growing data and reporting infrastructure. • Implemented Oracle GoldenGate for continuous data replication and delivery, reducing monthly data processing from 4 days to under 6 hours. • Deployed high availability architecture for financially relevant systems using SQL Server AlwaysOn, using GoldenGate replication to achieve platform migration within standard outage windows. • Designed and implemented new data warehousing and tabular analytical architecture in high availability using SQL Server AlwaysOn to facilitate a major business initiative. • Implemented at-rest encryption (TDE) across the entire SQL Server and Oracle estate to satisfy regulatory requirements and simplify compliance. • Led strategic planning and data classification initiatives in support of legal data reporting and privacy requirements for GDPR in the EU / UK, and CCPA in the US. Collaborated with security department to plan and ensure compliance with the NY DFS cybersecurity regulation. • Established an international standard for data access requests, reviews, and database creation. • Partnered with business leaders on major migrations and transfer for business divestitures across SQL Server and Oracle. • Collaborated with Oracle professional services for local application migrations to Oracle cloud, eliminating on-site servers, reducing infrastructure cost and improving performance and stability. • Designed and deployed a self-service portal in ASP.NET (VB.NET, C#) enabling internal auditors to access database settings and permissions reports, significantly reducing DBA workload.
Led a team of 21, including DBAs, Web server admins, SharePoint admins and a DevOps admin. Provisioned and operated servers for databases, websites, SharePoint infrastructure, and DevOps services, including patching, implementations, certificate management, access requests, migrations, performance monitoring, and troubleshooting. Collaborated with IT, audit, and compliance teams on data access reporting and requirements, and worked with application owners and business teams to support a growing application and data topology through acquisitions. • Adapted strategies and infrastructure to support rapid company growth and evolving IT demands. • Led multiple database integrations due to acquisitions, supporting or converting platforms including DB2, Oracle, PostgreSQL, Progress DB, QuickBooks, Access and FoxPro. • Designed and implemented a multiple environment development pipeline and deployment standards in SSIS and SSRS for data warehouse, ETL and reporting development. • Created and executed NLB solution with SSL offloading for web sites, web services, APIs and SQL reporting services. Supported 220+ web servers running 63 applications. • Deployed on-site git infrastructure on SELinux, enforcing repository-level security. Developed a web-based interface for git repository browsing and security requests in PHP. Facilitated migration to Azure DevOps. • Designed and implemented the SharePoint infrastructure through several integrations / acquisitions, version iterations, and scales of deployment, involving 43 servers at its peak. Facilitated consolidation and migration to SharePoint online, eliminating on-site infrastructure cost and maintenance.