Role

Database Manager

Experience

10+ Years

Industry type

IT Services & Consulting

Department

Engineering - Software & QA

Employment type

Full Time, Permanent

Role category

DBA / Data warehousing

Education

Any Graduate

Desired Candidate Profile

• Ability to create database design
• Help create Tables, SQL statements for data presentation and further automation
• Setting up and monitoring routine maintenance SQL jobs and developing / maintaining an alert strategy's for failed jobs and database problems and/or failures
• Good knowledge of implementation SAAS architecture
• Automatic deployments using CI/CD
• Good knowledge of deployment to multiple databases with zero downtime
• Ability to handle team, estimations and delivery
• Modify / update T-SQL scripts for importing and organizing data
• Work closely with analysts and other department personnel in advising best SQL coding practices
• Ability to manage multiple projects simultaneously within time and budget constraints
• Responsible for data profiling, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation
• Ability to implement SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services)
• Strong data management skills
• Good understanding of indexing, querying, and normalization
• Good understanding of relational database management system
• Good understanding of database integrity and security
• At least 5 years using MS SQL, data modelling, including an understanding of all normalized forms, design and development of stored procedures, views and triggers
• At least 5 + years of integrating SQL Server solutions in .NET environments, with working knowledge of C#, ASP.NET and SOA with web services
• Excellent attention to detail, ability to detect and correct problems within SQL scripts
• Sense of ownership and pride in your performance and its impact on company’s success
• Critical thinker and problem-solving skills
• Team player
• Good time-management skills
• Great interpersonal and communication skills

Roles and Responsibilities

• Designing, testing, and debugging software applications using SQL Server
• Collaborating with cross-functional teams to gather and analyse requirements
• Help write and optimize in-application SQL statements
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Handle common database procedures such as upgrade, backup, recovery, migration, etc
• Profile server resource usage, and optimize and tweak as necessary
• Collaborate with other team members and stakeholders