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:

A hiring company that offers alternative approaches to pay, performance bonuses, and/or equity in the firm is very attractive to you. You're generally less interested in working for an organization offering only traditional, salary-based compensation, one with limited opportunity to acquire equity in the firm, or one that does not actively promote skill development. In addition, you are more likely to choose a company that offers a variety of internal career options, with defined career paths. You view the learning of new skills and development of your expertise as key to your career advancement. These aspects of an organization may become even more important to you as you progress in your field, and are especially critical if you change career or occupation.

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: