M & T Bank Work Values

Daily Duties at M & T Bank:

o Provided 24 x 7 support for a highly transactional production environment. o Monitored, fine-tuned & trouble shot MS SQL Server performance and windows server issues. o Performed SQL Server installation, configuration and patching. o Managed and periodically changed passwords of service accounts and credentials as required. o Created maintenance plan for database backups, optimization (update statistics and reorganize index), database consistency checks and performed maintenance cleanup tasks. o Participated in system development life cycle (SDLC) and capacity planning for database deployment and configurations. o Configured SQL server on two and three node clusters in a production environment. o Performed regular database administration activities such as jobs monitoring, troubleshooting, backup verification and jobs scheduling as well as responded to disk space alerts on a daily basis. o Troubleshot all types of clustering issues and solved successfully. o Implemented HADR solutions including log shipping, mirroring, clustering, replication and Always-On Availability Groups. o Implemented cluster based mirroring from one data center to another data center. o Developed SSIS packages to extract, transform, and load (ETL) data from/into different sources. o Used MSSQL Profiler and generated traces to optimize the performance of the database. o Identified missing indexes and notified developers to improve database performance. o Resolved locking and blocking issues. o Worked on Active directory. o Planned and modified permission issues in the production servers. o Updated old versions of MS SQL to current versions. o Migrated data from an old version of MS SQL to an updated version. o Installed and configured different versions of SQL Server in a Test Environment. o Automate dbcc maintenance activities on Database tuning by setting configuration parameters. o Implemented and maintained policies, procedures and standards to ensure security and integrity of test and production data. o Worked in Customer-centric role, where customer interaction happens via Email, phone calls and direct reports. o Perform index rebuilding on a weekly basis due to high volume of I/O. o Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O. o Used a third party tool (IDERA) to monitor and improve the performance of the server. o Worked with SharePoint and remedy force ticketing systems o Participated in upgrading of MS SQL Server 2014 to MS SQL Server 2016. o Developed DTS and SSIS packages to extract, transform, and load (ETL) data into the Company database from OLTP database also form Data Warehouse. o Worked with Database Development team. o Created Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors

What they like about M & T Bank:

Working in an organization that is technologically advanced, creative, and innovative is critical in your assessment of hiring companies. Less important to you are stability of the organization, the length of time an organization has been in business, and the business' plans for the future. You prefer a fast-moving company that will take risks to achieve its goals and objectives. The length of time the company has been in business is irrelevant. Maintaining status quo is unnecessary. You thrive on change, uncertainty and the upside of potential business risks, especially those associated with innovation. Stability for the long haul is not nearly as important as is working in an atmosphere that is charged with a sense of urgency and constant change.

Tags

Clustering, Disaster Recovery, Install, Microsoft SQL Server, Monitoring, Replication, Servers, Structured Query Language, Security, Microsoft Windows, sql, Always On, OLTP Servers, OLAP Server

Skills

T_sql programming

These are some of the questions we asked our climbers about their experiences with M & T Bank: