Create and manage multiple databases and assist in capacity planning. Monitor, maintain database systems and troubleshoot problems that may arise. Maintain data integrity, monitoring and security (manage roles and permissions of database users). Use tools like Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them. Develop strategies and implement solutions for managing back-ups, restoration and replication. Create and manage constraints and indexes. Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures. Proactive housekeeping/archiving and shrinking of databases. Job Description Senior Database Administrator. Manage production, QA and development database environments. Create detailed documentation including diagrams of database infrastructure. Learn relevant business processes and understand the data flow, criticality and dependencies. Effectively coordinate and communicate with all the stakeholders (internal teams and clients). Set up and maintain database infrastructure for the company’s BI needs.