Resume

Sign in

Manager Security

Location:
Danbury, Connecticut, United States
Salary:
130,000
Posted:
November 02, 2018

Contact this candidate

Resume:

Summary:

Seeking an opportunity to work for a great company, where I may continue to apply my knowledge and expertise to develop, implement, and oversee database policies and procedures to ensure the integrity and availability of SQL databases. I am self-motivated and meticulous concerning my work. Ideally, I would like to lead a team of database administrators and work with them on all areas of SQL.

Experience:

Project Manager - DBA April 2011 – Present

Nestle Global Team 900 Long Ridge Rd, Stamford, CT

• Lead presenter for the SQL Server global community.

• Maintaining complex global environments ~5,500 servers.

• Supported the entire life cycle of the applications: installations, upgrades, configurations, and troubleshooting.

• Design, implement, and execute Security and Compliance Activities on all our SQL Servers.

• Responsible for improving Security and Compliance KPI’s and putting them within the compliant range (98-99%) without a single business disruption.

• Maintained a very simple but robust backup and maintenance routine. I my 28 years as a database administrator I have never lost a byte of information.

• Implemented many automatic processes and reports to help us track: backup and maintenance routines are running properly, SQL Server patch Level, User management…

• Create standard routines for Security and Compliance Activities related to SQL Servers.

• Wrote database documentation: Standard Routines, Controls, including data standards, procedures, and definitions for the data dictionary (metadata).

• Dismantled my SQL Inventory to integrate many of its features into the now existing Global System Inventory, using TSQL, Power shell, cmd and bcp scripts.

• Installed, configured and worked with Microsoft Reporting and Analysis Services (SSRS, SSAS)

• Increase level of user validations, rights, and overall access to data such as controlling access permissions and privileges.

• Provide technical architecture leadership to team members.

• Responsible for the performance, integrity, and security of the databases.

• Assist team members on performance, integrity, and security of databases.

• Created and troubleshoot: Transact SQL, Stored procedures, Views, Triggers, Functions…

• Security and disaster recovery of the business, in response to increasing threats of hacking and sensitive nature of data stored.

• Single point of contact on specific projects such as remediating security and compliance audit points in collaboration with coworkers in Mexico, Spain, and Switzerland, disaster recovery solutions and disabling unused accounts globally.

Database Team Manager - DBA December 2006 – April 2011

Nestle CATI Team 900 Long Ridge Rd, Stamford, CT

• Provided leadership to the North American and Canadian database teams.

• Responsible for the maintenance, security, and administration of 1,500 SQL Database Servers primarily in North America.

• Delegated project duties to appropriate team members.

• Participated in the architecture design, programming, troubleshooting, and security needs of the applications.

• Leveraged SQL Server Reporting Services to create up-to-date reports on our large SQL Environment.

• Created and tracked SQL Servers KPI’s, backup status, SQL Versions upgrades, maintenance routines, and user management using my SQL Server Inventory system.

• Developed and enforced database standards and controls.

• Informed senior management of database policies, standards, and controls.

• Developed and presented system status updates to the management team.

• Participated with system administrators to evaluate software and hardware upgrades.

• Assisted database administrators to evaluate system performance, upgrades, and improvements.

Senior Database Administrator June 2000 – December 2006

Nestle Waters North America 777 West Putnam Ave, Greenwich CT

• Hired to manage ~30 SQL Servers in 2000, had increased to ~400 SQL Servers by 2006.

• Designed and implemented a SQL Server System Inventory.

• Performed hundreds of installations, upgrades, configurations, and troubleshooting.

• Communicated and collaborated regularly with every level of the organization: CIO, managers, technical, applications, operational groups, and consultants.

• Responsible for the installation, upgrades, and testing of all SQL Versions.

• Responsible for the performance, integrity, and security of the databases.

• Wrote database documentation including data standards, procedures, and definitions for the data dictionary (metadata).

• Developed, managed, and tested capacity and recovery efforts.

• Ensured that storage and archiving procedures were functioning correctly.

Senior Programmer March 1992 – June 2000

Iona College 715 North Ave, New Rochelle, NY

• Responsible for the purchase and management of various PeopleSoft modules Including installing, maintenance, patching, upgrades and racking of servers.

• Developed an automated transcript program that helped the Registrar's Office validate the minimum requirements of potential graduates, saving the office hundreds of hours of manual work.

• Developed an automated process using Microsoft Access that would allow administrators to submit the student reports from their desks, saving them hours and avoiding manually going to operations department.

Education:

M.B.A., Management Information Systems, Iona College, New Rochelle, New York

B.A., Computer Science, Iona College, New Rochelle, New York

Additional Skills:

Languages: Fluent in English and Spanish

Programming: T-SQL, Store Procedures, PowerShell, SQL Server Reporting Server and Command Shell

Products: Windows and all SQL Server versions, Reporting Services, Analysis Services, Integration Services



Contact this candidate