Michael Brule Email & Phone Number

Proud member of The Great Retirement

Microsoft SQL Server Database Administration in a managed services environment. Skill Summary•Database Management Systems: Microsoft SQL Server 2008 - 2017•Operating Systems: Windows Server 2008 - 2016•Languages: Transact-SQL, DOS Batch, VBScript, PowershellResponsibilities•Performance tuning of application queries, views, procedures and functions•Review and implement production and non-production change requests•Participate in management reviews of production changes•Participate in on-call rotation•Update daily, weekly and monthly status reports•Provide monthly and quarterly health check reports to application stakeholders•Provide database consulting services as needed by application teams

Enterprise-wide installation, 24X7 support and maintenance of Microsoft SQL Server in a mature, managed financial services environment. Skill Summary•Database Management Systems: Microsoft SQL Server 2000 - 2014•Operating Systems: Windows Server 2003 - 2012•Languages: Transact-SQL, DOS Batch, VBScript, PowershellAccomplishments• Architected and implemented an Always On HADR cluster using SQL Server 2012 for a critical new high-performance application.•Migrated several mission-critical databases from Sybase to SQL Server. •Worked with developers to implement a 10TB database for hedging analysis. Provided physical design and partition schemes for larger fact tables. •Worked with Security Risk Management to develop enterprise security specifications for the SQL Server environment based on DOD standards. Created health-check processes to monitor compliance. Worked with DBA and application teams to remediate violations.•Created a library of VB Scripts to allow DBAs to access OS and SQL Server information from their desktops without having to log in with a Remote Desktop session.

Skill Summary•Database Management Systems: Microsoft SQL Server, Sybase Adaptive Server•Operating Systems: Windows NT/2000/2003, NCR Unix•Languages: Transact-SQL, ANSI SQL, HTML, DOS Batch, VBScript•Other: CA-Autosys SchedulingKey Contributions•Implemented a distribution and verification process to distribute database changes to more than 50 remote servers in a uniform manner and to verify application of the changes.•Developed procedures and scripts to migrate production databases, logins and scheduled jobs to new hardware installations for 53 remote locations.•Re-engineered ETL process for ordering and inventory applications; significantly improving performance and reliability.

Evaluate the SQL Server environment for an enterprise Human Resources application and an enterprise Customer Relationship Management system. Propose recommendations to enhance database security and recoverability. Execute priority recommendations to hasten production implementation of applications.

Skill Summary•Database Management Systems: Microsoft SQL Server, Oracle Rdb, Oracle 8i•Operating Systems: Windows NT/2000, OpenVMS, AIX•Languages: Transact-SQL, ANSI SQL, HTML, Visual Basic, MS Access, DOS Batch, VBScriptKey Contributions•Designed and implemented Phoenix’ first SQL Server 2000 environment and its accompanying policies and procedures.•Designed, implemented and tested Phoenix’ first SQL Server disaster recovery environment to use hardware-mirrored storage and boot-from-SAN methodology. Developed and published recovery procedures.•Created an information repository containing details of every user’s permissions within the SQL Server environment for use by Corporate Audit to assure Sarbanes-Oxley compliance.•Migrated four production and two test SQL Server 7.0 servers to a SAN as part of the disaster recovery environment implementation.•Developed server consolidation plan to reduce the server population, reduce licensing costs by over 50% and position the SQL Server 7.0 environment for upgrade to SQL Server 2000.•Worked jointly with the Senior Oracle Rdb DBA to migrate the current VAX/VMS Rdb environment to a new Alpha/VMS implementation.•Created and maintained a departmental Intranet website to disseminate information to the applications community and host reference information for the Database Administration team.•Created a Visual Basic application to permit Help Desk personnel to change SQL Server passwords, freeing both the Security and Database teams from this responsibility.