Database Administrator Ii

Are you our “TYPE”? Monotype Global Named "One of the Most Innovative Companies in Design" by Fast Company, Monotype brings brands to life through type and technology that consumers engage with every day. The company's rich legacy includes a library that can be traced back hundreds of years, featuring famed typefaces like Helvetica, Futura, Times New Roman and more. Monotype also provides a first-of-its-kind service that makes fonts more accessible for creative professionals to discover, license, and use in our increasingly digital world. We work with the biggest global brands, and with individual creatives, offering a wide set of solutions that make it easier for them to do what they do best: design beautiful brand experiences. Monotype Solutions India Monotype Solutions India is a strategic center of excellence for Monotype and is a certified Great Place to Work® three years in a row. The focus of this fast-growing center spans Product Development, Product Management, Experience Design, User Research, Market Intelligence, Research in areas of Artificial Intelligence and Machine learning, Innovation, Customer Success, Enterprise Business Solutions, and Sales. Headquartered in the Boston area of the United States and with offices across 4 continents, Monotype is the world’s leading company in fonts. It’s a trusted partner to the world’s top brands and was named “One of the Most Innovative Companies in Design” by Fast Company. Monotype brings brands to life through the type and technology that consumers engage with every day. The company's rich legacy includes a library that can be traced back hundreds of years, featuring famed typefaces like Helvetica, Futura, Times New Roman, and more. Monotype also provides a first-of-its-kind service that makes fonts more accessible for creative professionals to discover, license, and use in our increasingly digital world. What you’ll be doing: - Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures. - Effectively coordinate and communicate with all the stakeholders (internal teams and stakeholders). Advise developers on the most efficient database designs. Set up and maintain database infrastructure. - Learn relevant business processes and understand the data flow, criticality and dependencies. - Troubleshoot SQL Server service outages as they occur, define SLA and ensure support when required. - Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them. - Enhancements and Improvements to Existing Database Systems Infrastructure. - Determine the most effective way to increase performance including hardware recommendations, server configuration changes, performance tuning etc. - Setup and test High-Availability as part Disaster Recovery Strategy for the Databases to ensure ability to meet the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO). - Execute data migrations to/from various platforms/engines and database upgrades. - Maintain data integrity and security (manage roles and permissions of database users). - Manage production, staging, and development database environments. - Proactive housekeeping of databases. - Configure SQL Server monitoring utilities to minimize false alarms. - Create detailed documentation including diagrams of database infrastructure. Key Responsibilities: Database Administration: - Manage databases: MS SQL Server, MySQL, PostgreSQL, MongoDB, Oracle. - Administer AWS RDS for MySQL, PostgreSQL, SQL Server. - Implement master-slave, active-active, and backup strategies. - Optimize performance and conduct query analysis. Cloud and Tools: - Use AWS services: Redshift, S3, RDS. - Implement SQL Server clustering and high availability (HA) technologies. - Utilize SQL Server management tools like Redgate. What we’re looking for: - 4+ years working experience in Advanced administration of database like MS SQL server, MySQL (incl. Amazon Aurora) - Working knowledge in MySQL and In-Memory Databases (Redis, MongoDB, etc) - Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems. - Experienced in SQL Server Integration Services (SSIS) - Experienced in ETL (Extract-Transform-Load) development / data integration. - Experience in creating data hooks for analytics tools like - PowerBi, Tableau, Insights. - Sound knowledge of RDBMS concepts, database design and SQL/T-SQL. - Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage. - Have knowledge of SQL Server management tools like Redgate etc. - Knowledge of various database platforms (SaaS, PaaS, IaaS, etc.) - Good to have experience on Mulesoft. - Postgres sql and sound knowledge of oracle - Has an innovative approach to work, constantly looking to upg