Sr. Database Administrator

Duties and Responsibilities Responsible for ensuring availability and performance of all company databases. Work to ensure that the proper hardware resources are allocated to the databases, and to ensure high resilience and performance tuning. To proactively monitor the database systems to ensure secure services with minimum downtime. Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management. Responsible for troubleshooting and problem solving SQL development issues. Responsible for assisting developers to optimize, tune and enhance database queries. Responsible for improvement and maintenance of all databases, to include rollout and upgrades. Responsible for implementation and release of database changes according to agreed timescales and costs. Responsible for proposing and implementing database architectural changes to make database infrastructure highly scalable and optimized. Client operates a 24x7 environment. On-call / off-hours deployments and support will be required. To take on technical leadership responsibilities of database projects across various teams in the organization. Responsible for mentoring developers on data modeling best practices and enabling them to come up with an optimized data model. Skills / Attributes Required Masters in Computer Science or related field. 8+ years of in-depth SQL Server Database Administration experience. Extensive experience of managing multiple MS SQL 2008/2012/2014/2016 servers on enterprise-class servers clusters running Windows 2003/2008/2012. Strong self-sufficiency and initiative working on Database projects. Experience in leading and mentoring team members. Practical experience in monitoring and tuning a database to provide a high availability service. Experience with T-SQL, OLAP, DTS, SSIS and stored procedures. Practical experience in managing internal and external Microsoft SQL Server database security. Strong knowledge of Multi-Instance implementations and methodologies. Experience with Replication, Log Shipping, Change Data Capture and Database Mirroring. Knowledge of SQL Service Broker. Understanding of High Availability, Business Continuity, and Disaster Recovery concepts as they relate to Open Systems architecture. Experience on working with SQL Server in Amazon cloud or/and Azure platform is definitely a plus. Experience of working with mysql database and knowledge of NoSQL databases. Job Type: Full-time Salary: $120,000.00 to $140,000.00 /year Experience: T‑SQL: 8 years (Preferred) MySQL: 8 years (Preferred) Database Administration: 8 years (Preferred) managing multiple MS SQL 2008/2012/2014/2016 servers: 8 years (Preferred) T‑SQL, OLAP, DTS, SSIS and stored procedures: 8 years (Preferred) #J-18808-Ljbffr