Chief Database Architect

Job Description:

Our team is seeking a skilled Database Developer to design, develop, and maintain efficient database solutions using SQL Server, SSIS, or other ETL tools. As a key member of our database development team, you will create and manage ETL processes to extract, transform, and load data from multiple sources into databases or data warehouses.

Key Responsibilities:

• Design, develop, and maintain efficient database solutions using SQL Server, SSIS, or other ETL tools.
• Create and manage ETL processes to extract, transform, and load data from multiple sources into databases or data warehouses.
• Develop stored procedures, views, functions, and triggers to support application development.
• Optimize database performance by tuning queries, indexes, and other database components.
• Collaborate with data architects, business analysts, and other teams to ensure that business needs are met through data solutions.
• Create and schedule SSIS packages to automate data workflows.
• Troubleshoot and resolve database performance, data integrity, and data quality issues.
• Ensure proper documentation of database architecture, ETL processes, and reporting requirements.
• Maintain data security and compliance standards, ensuring data privacy regulations are adhered to.
• Implement and maintain database backup, recovery, and disaster recovery strategies.
• Strong experience in writing complex SQL Queries using Joins, Hints, indexes, etc.
• Should have worked on different file handling techniques, SQL Loader, UTL File, External Tables, etc.
• Should be aware of Oracle 11g features.
• Help write and optimize in-application SQL statements.
• Ensure performance, security, and availability of databases.
• Prepare documentations and specifications.
• Profile server resource usage and optimize and tweak as necessary.
• Collaborate with other team members and stakeholders.
• Translate business needs to technical specifications.
• Design, build and deploy BI solutions (e.g., reporting tools).
• Maintain and support data analytics platforms (e.g., MicroStrategy).
• Create tools to store data (e.g., OLAP cubes).

Required Skills and Qualifications:

• Strong knowledge of SQL, including the ability to write complex queries, stored procedures, and triggers.
• Experience with SSIS or any other ETL tool (e.g., Informatica, Talend, Pentaho).
• Expertise in creating and optimizing ETL workflows, automating data loads, and transforming large datasets.
• Experience with database management systems (e.g., SQL Server, Oracle, MySQL).
• Knowledge of data modeling and database design concepts.
• Familiarity with data warehousing concepts and best practices.
• Experience with performance tuning and query optimization.
• Strong problem-solving skills and ability to debug complex database issues.
• Understanding of version control systems and Agile development methodologies.

Benefits:

• Opportunity to work with a talented team of professionals.
• Chance to develop and implement innovative database solutions.
• Competitive salary and benefits package.