Francis Mazeika
Director of Information Architecture at CMI Media Group- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
Topline Score
Bio
Matthew Peters
Francis was a breath of fresh air in the morning in a very difficult working environment. He has all the qualities I would look for in a peer or supervisor role. His combination of being a very likable person and vast knowledge of SQL Server seperate him from rest.
Chyllene Cattie, CEDS, CeDP
I had the pleasure of working with Fran during our tenure at Dechert. Fran and I were responsible for troubleshooting database and server problems with respect to applications being used by litigation department members for large cases. Fran was instrumental in identifying some programming code issues and working with the software vendor to test and implement solutions. Fran also wrote some custom code to assist the department in executing daily complex searches within the SQL database rather than through the user interface which was creating additional overhead and extraneous database calls. Given the opportunity, I would gladly work with Fran again and would welcome his expertise.
Matthew Peters
Francis was a breath of fresh air in the morning in a very difficult working environment. He has all the qualities I would look for in a peer or supervisor role. His combination of being a very likable person and vast knowledge of SQL Server seperate him from rest.
Chyllene Cattie, CEDS, CeDP
I had the pleasure of working with Fran during our tenure at Dechert. Fran and I were responsible for troubleshooting database and server problems with respect to applications being used by litigation department members for large cases. Fran was instrumental in identifying some programming code issues and working with the software vendor to test and implement solutions. Fran also wrote some custom code to assist the department in executing daily complex searches within the SQL database rather than through the user interface which was creating additional overhead and extraneous database calls. Given the opportunity, I would gladly work with Fran again and would welcome his expertise.
Matthew Peters
Francis was a breath of fresh air in the morning in a very difficult working environment. He has all the qualities I would look for in a peer or supervisor role. His combination of being a very likable person and vast knowledge of SQL Server seperate him from rest.
Chyllene Cattie, CEDS, CeDP
I had the pleasure of working with Fran during our tenure at Dechert. Fran and I were responsible for troubleshooting database and server problems with respect to applications being used by litigation department members for large cases. Fran was instrumental in identifying some programming code issues and working with the software vendor to test and implement solutions. Fran also wrote some custom code to assist the department in executing daily complex searches within the SQL database rather than through the user interface which was creating additional overhead and extraneous database calls. Given the opportunity, I would gladly work with Fran again and would welcome his expertise.
Matthew Peters
Francis was a breath of fresh air in the morning in a very difficult working environment. He has all the qualities I would look for in a peer or supervisor role. His combination of being a very likable person and vast knowledge of SQL Server seperate him from rest.
Chyllene Cattie, CEDS, CeDP
I had the pleasure of working with Fran during our tenure at Dechert. Fran and I were responsible for troubleshooting database and server problems with respect to applications being used by litigation department members for large cases. Fran was instrumental in identifying some programming code issues and working with the software vendor to test and implement solutions. Fran also wrote some custom code to assist the department in executing daily complex searches within the SQL database rather than through the user interface which was creating additional overhead and extraneous database calls. Given the opportunity, I would gladly work with Fran again and would welcome his expertise.
Experience
-
CMI Media Group
-
United States
-
Advertising Services
-
700 & Above Employee
-
Director of Information Architecture
-
May 2016 - Present
Dynamic information architect, database administrator and group leader with success developing information innovation Passionate senior technology leader offers fresh insight and passion for information development. Proven track record as a planner, designer, developer, team builder and visionary. Passionate architect known for achieving excellence in data management and for developing a competitive advantage in midsized and large projects. Solid background and qualifications in core database best practices and advanced information architecture. Proficiencies: Managed and lead DBA’s and Developers. DBA for AWS Redshift; ETL Manager Managed on prem and migrated and managed SQL Server on Azure. Install, Configure and manage all SQL Server versions. Proficient with DBCC’s, DMV’s, Extended Events, SQL Profiler and Trace Flags. Identify and resolve a wide range of performance issues. Installed SQL on Stand-Alone Servers, VM’s, MS OS Clusters (HA) and AZURE. Enabled and Configured Transactional Replication, Log Shipping and Database Mirroring. Designed, Implemented and Maintained Backup-Restore Architectures, process, and procedures, Designed, Implemented and Maintained Disaster Recovery Architectures (DR), processes and procedures. Communicate, in non-technical terms. Work independently or within a group. Show less
-
-
-
Verinext
-
United States
-
IT Services and IT Consulting
-
200 - 300 Employee
-
MS SQL DBA
-
Aug 2014 - Apr 2017
MS SQL DBA for Anexinet at BDP International •Install, Configure SQL Server 2012-2016 on Stand-Alone, Failover Cluster and AZURE platforms. •Responsible for proactively monitoring performance, data integrity of production and test databases. •Perform general database administration duties. •Plan, schedule and implement DB upgrades or enhancements. •Managed integration of databases with other related internal databases (ETL). •Create and maintain documentation. •Perform timely analysis, diagnosis and resolution of complex database issues •Create and update reports on DB Performance. •Liaison with third party vendors on design enhancements or DB modifications to meet new business needs. •Provide end user support. •Proactively follow and actively promote all department policies, procedures and companies Core Values. •Establish database and coding standards, educate staff on policies and procedures, monitor compliance. Show less
-
-
-
-
Principal
-
Mar 2010 - Apr 2017
Technical Software Solutions Company. Technical Software Solutions Company.
-
-
-
InstaMed, a J.P. Morgan company
-
United States
-
Information Technology & Services
-
300 - 400 Employee
-
Manager Database Administration
-
May 2012 - Aug 2014
•Managed the company’s corporate and customer facing databases. •Subject matter expert on all database related issues, questions and technologies. •Migrated customer databases to new architecture\configuration •Monitored and improved database reliability and speed. •Worked with development on changing coding practices to improve database performance. •Interfaced with internal users to identify and correct application issues that affected our customers. •Created and tested DR processes and procedures. •Created Benchmark Testing Standard for all new installs; TPC-C. Show less
-
-
-
Vertical Screen LLC
-
Marlton NJ
-
MS SQL DBA
-
Sep 2011 - May 2012
MS SQL Server DBA •Monitored and improved database performance leveraging SQL Profiler and Performance Monitor. •Duties included review and tuning of application, development code. •Created DBCC scripts to keep performance optimal. •Created, maintained, tested backup\restore and disaster recovery processes using Database Mirroring. •Assisted Development in the new application architecture design. •Designed and implemented ETL processes for the Data warehouse. •Upgrade SQL Server from SQL 6.5 to SQL 2000 then to SQL 2008 R2. Show less
-
-
-
SI Organization
-
Defense & Space
-
100 - 200 Employee
-
Database Engineer
-
Mar 2011 - Aug 2011
Installed SQL Server 2008 R2 Enterprise on Windows 2008 R2. Designed\architect and created the SQL Test, Production and DR environments. Supported the development group on database and TSql issues and questions. Final level support on SQL Server issues and questions. Managed SQL Server 24/7. Monitor database performance leveraging SQL Profiler and Performance Monitor Tools. Duties included review and tuning of application, development and vendor code. Proficient with DBCC’s, writing Stored Procedures, Views and Triggers. Created, implemented, maintained and tested backup\restore and disaster recovery procedures. Maintained industry standards and best practice guidelines where I could. Administrator of user privileges and security within the database environment. Developed processes and procedures for code release and patch management. Participated in application architecture design, Data Warehouse and Data conversion methodologies. Managed SQL Servers on VM. Installed and configured Share Point. Show less
-
-
-
Battelle
-
United States
-
Research Services
-
700 & Above Employee
-
MS SQL Server DBA
-
Jan 2011 - Mar 2011
Hardware and software performance tuning, query and table optimization of the SQL Server 2008 R@ Enterprise databases for the PeopleSoft HR application. Streamlined processes to improve ETL throughput for Informatica. Hardware and software performance tuning, query and table optimization of the SQL Server 2008 R@ Enterprise databases for the PeopleSoft HR application. Streamlined processes to improve ETL throughput for Informatica.
-
-
-
Pinnacle Foods
-
United States
-
Food and Beverage Services
-
700 & Above Employee
-
Senior MS SQL Server DBA
-
Jul 2010 - Feb 2011
Administer over 100 production SQL Servers (2000,2005,2008,2008 R2) supporting over 600 databases in a 24/7 environment. Monitor production database performance leveraging SQL Profiler and Performance Monitor Tools. Duties included review and tuning of application, development and vendor code. Proficient with DBCC’s, writing Stored Procedures, Views and Triggers. Created, implemented, maintained and tested backup\restore and disaster recovery procedures. Maintained industry standards and best practice guidelines. Prepared database environment for SOX/security audits. Part of the team that built the Data Warehouse for BI. Administrator of user privileges and security within the database environment. Developed processes and procedures for code release and patch management. Experience in application architecture design Data Warehouse and Data conversion methodologies. Installed and configured Team Foundation Server. Show less
-
-
-
Philadelphia Insurance Companies
-
United States
-
Insurance
-
700 & Above Employee
-
Senior MS SQL Server DBA
-
Apr 2010 - Jul 2010
Administer over 40 production SQL Servers (2005, 2008, 2008 R2) supporting over 300 databases that included multi terabyte databases in a 24/7 environment. Upgraded SQL Server from 2000, 2005 to 2008 R2. Installed SQL Server 2008 R2 on Windows cluster on the SAN. Monitor production database performance leveraging SQL Profiler Performance Monitor and Idera Tools. Duties included review and tuning of application\development and vendor code. Proficient with DBCC’s, writing Stored Procedures Views Triggers. Installed configured and deployed SSIS SSRS. Experienced in configuring replication and log shipping. Created maintained and tested backup\restore and disaster recovery procedures. Managed SQL Servers on VM. Maintain industry standards and best practice guidelines in knowledge exchange meetings. Managed database security. Experience in application architecture design Data Warehouse and Data conversion methodologies Show less
-
-
-
Prizm, Medical Bill Review Specialist
-
United States
-
Insurance
-
1 - 100 Employee
-
Senior MS SQL Server DBA
-
Jul 2009 - Mar 2010
Installed monitored and maintained MS SQL 2000, 2005, 2008, SSRS in a 24/7 environment. Managed database security. Monitor database performance leveraging SQL Profiler and Performance Monitor. Developed backup recovery and DR procedures. Responsible for monitoring and tuning of application\development and vendor code. Installed high availability architectures leveraging replication, log shipping, SQL cluster on a SAN. Managed SQL Server on a VM. Proficient with DBCC’s, writing Stored Procedures Views Triggers and DTS packages. Implemented industry standards and best practice guidelines in knowledge exchange meetings. Developed processes and procedures for code releases and patch management. Experience in application architecture design Data Warehouse and Data conversion methodologies. Show less
-
-
-
NFI
-
United States
-
Transportation, Logistics, Supply Chain and Storage
-
700 & Above Employee
-
Senior MS SQL Server DBA
-
Sep 2007 - Jul 2009
Installed monitored and maintained MS SQL 2000, 2005, 2008, SSIS SSAS in a 24/7 environment. Participated in application architecture design, built Data Model, Data Marts, Data Warehouse, and ETL conversion scripts. Proficient with DBCC’s, writing Stored Procedures Views Triggers and DTS. Managed database security. Monitor database performance leveraging SQL Profiler and Performance Monitor. Responsible for monitoring and tuning application\development and vendor code. Developed backup, recovery and DR procedures. Installed SQL 2008 on Windows Cluster. Established high availability architectures leveraging DB replication log shipping SQL cluster and SAN. Experience in managing SQL Server on a VM. Managed testing and implementing of SQL Server patches. Show less
-
-
-
Commerce Bank NA
-
Mt Laurel, NJ
-
MS SQL Server DBA, Officer
-
Jan 2005 - Jul 2007
Managed two direct reports. Experienced in leading migration conversion and re-engineering projects. Hands on experience with installing and maintaining SQL 2000 2005. Configured database severs. Established disaster recovery and high availability architectures leveraging db replication log shipping SQL cluster and SAN. Responsible for monitoring then tuning of application\development code. Experience writing stored procedures views and triggers. Experience in managing SQL Server on a Virtual platform. Experienced in implementing and monitor DB Security. Configured implemented and monitored database maintenance jobs. Have worked within large and small groups and can work independently. Show less
-
-
-
Aecio Technology Group
-
IT Services and IT Consulting
-
Senior MS SQL Server DBA
-
Jan 2004 - Jan 2005
Duties included monitoring, analyzing then making performance recommendations. Created backup and recovery procedures using log shipping, SQL Cluster Architecture as well as SAN technology. Created Stored Procedures, Triggers and Views for various in-house applications. Worked with development on performance tuning. Worked with the NOC on creating SQL Server specific server builds. Duties included monitoring, analyzing then making performance recommendations. Created backup and recovery procedures using log shipping, SQL Cluster Architecture as well as SAN technology. Created Stored Procedures, Triggers and Views for various in-house applications. Worked with development on performance tuning. Worked with the NOC on creating SQL Server specific server builds.
-
-
-
Dechert LLP
-
United States
-
Law Practice
-
700 & Above Employee
-
Senior Technical Architect
-
Jun 2001 - Jan 2004
Data Modeler - Senior SQL Server 7,2000 DBA Analyze, design, implement, test, tune, document and manage databases and objects, which include tables, views, indexes, stored procedures, triggers and DBCC's. Supervise and perform database installations and upgrades. Support development, testing and production database environments. Administer database security management. Create and maintain user profiles and passwords granting and revoking access to applications, databases and system resources. Provide trend analyses reports for current needs and forecasting future resource requirements. Coordinate and maintain relationships with multiple internal user groups and departments to improve communication between applications in a 24/7 international environment. Show less
-
-
-
Emerald Solutions Inc
-
Bridgewater, NJ
-
Senior Technical Architect
-
Jun 1999 - May 2001
Supervised junior DBA's and programmers. Technical Project Lead. Managed day-to-day activities of in-house and remote applications in a 24/7 environment. Leveraged resources as needed throughout each project life cycle. Coordinated with other project leads to ensure timely delivery of applications within budget. Liaison with customers to resolve issues and enhance product usability. Experience in application architecture design, Data Modeling, Data Marts, Data Warehouse Data conversion. Created database standards for query structures, naming convections, error handling and report requests. Senior SQL Server DBA 6.5 and 7.0, Windows NT Admin, Visual SourceSafe Admin, IIS Admin. Other duties included writing DBCC programs, Stored Procedures, Views, Triggers, performance tuning, benchmarking, documentation, troubleshooting and problem solving. Developed backup and recovery procedures. Implemented 'Database Rate of Growth' impact projection analysis, delivered via SQL Mail. Show less
-
-
-
Virtua Health
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
Lead Technical Specialist
-
Jun 1996 - Jun 1999
Technical manager for a variety of projects. Maintained favorable vendor relations and partnerships throughout the entire project development life cycle. Liaison with internal user groups, departments, physicians and senior administration on relevant IS applications. Developed, maintained and enhanced where necessary data standards in the Data Warehouse and Repository. Streamlined bill processing which eliminated third party software that resulted in a savings of $5,000,000. Replaced third party application with in-house programs, which saved over $10,000 per month in maintenance. OLAP SQL Server 6.5 Data Base Administrator on a Windows NT 4.0 platform. Show less
-
-
-
The Wharton School
-
United States
-
Higher Education
-
700 & Above Employee
-
Lead Programmer Analyst
-
Dec 1990 - Jun 1996
Responsible for developing, maintaining and improving programs, policies and procedures. Analyzed and improved financial reporting and streamlined the transfer of data using various 4gl languages. Liaison with various user groups and departments and senior administration. Responsible for developing, maintaining and improving programs, policies and procedures. Analyzed and improved financial reporting and streamlined the transfer of data using various 4gl languages. Liaison with various user groups and departments and senior administration.
-
-
-
Amtrak
-
United States
-
Rail Transportation
-
700 & Above Employee
-
Train Car Inspector
-
Apr 1979 - Dec 1990
-
-
Education
-
Maple Shade High School
High School, General