Responsibilities
• Monitor the performance of hardware and software.
• Develop, implement and optimize stored procedures and functions using T-SQL
• Develop and optimize existing queries and create new queries as required by the business team / development team
• Develop, manage and maintain integrations with external applications via SQL replication or stored procedures.
• Demonstrate DBA skills such as SQL Trace, SQL Server Profiler and SQL Server Change Data Capture
• Install and configure new SQL Servers.
• Participate in the design, development, and analysis of data architecture approach.
• Review code and provide feedback relative to best practices, performance improvements etc.
• Troubleshoot production support issues post deployment and come up with solutions as required.
• Perform optimization of complex MS SQL queries and packages to ensure top performance.
• Perform business process re-engineering on existing reporting and analytics and leverage new technology to create better ways to analyze and act on data.
• Develop processes, and procedures to facilitate the efficient use of views.
• Update the data dictionary and ERD every release.
• Diagnose and remedy performance issues in a production data system and web servers.
• Operational experience performing relational database upgrades and data migrations.
• Identify actionable insights, suggest recommendations and influence the direction of the business by effectively communicating findings to cross-functional groups.
• Analyze complex data from multiple sources, you'll be responsible for detecting problems with the database and suggesting improvements that will have immediate impact.
Requirements
• Typically requires a bachelor’s degree in Computer Science or other IT degree and 8+ years of experience
• Ability to independently prepare detailed database schemas, upgrade scripts, stored procedures, and triggers.
• Ability to debug and optimize performance issues with queries and stored procedures
• Ability to review and understand different integration touch points with external systems and monitor them for errors and performance issues
• Ability to develop, implement and optimize stored procedures and functions using T-SQL
• Ability to understand, diagnose, and remedy performance issues in a production data system and web servers.
• Practical experience with different database architectures and deployment models.
• Business awareness and understanding of business requirements of IT.
• Experience with SSIS and SSRS