Description

You will design, develop, and implement complex, scalable database systems and infrastructure to meet organizational requirements.

Responsibilities

• Design and develop efficient, scalable, and secure database architectures, including data storage and indexing techniques.
• Build relational data models, tables, views, functions, grants, triggers, stored procedures, and indexes.
• Manage back-end data integration, dimensional data modeling, data warehousing, ETL development, and performance tuning.
• Execute database migration projects, specifically from Oracle to SQL Server.
• Design and maintain High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
• Develop DB deployment strategies and maintenance plans across multiple environments.
• Collaborate with software developers and system administrators to ensure performance and scalability.
• Implement security protocols including encryption, access controls, and data backup/recovery procedures.

Required Skills

• 5+ years of experience in database architecture and development.
• Hands-on experience with SQL Server and Oracle.
• Expertise in Data Warehousing and ETL development.
• Proven experience with dimensional data modeling and partitioning.
• Experience with Microsoft Power BI stack.
• Strong knowledge of Windows Server and Active Directory for user access management.
• Experience designing and implementing cloud-based data management solutions.
• Ability to work independently with minimal supervision to solve complex architectural problems.

Preferred Skills

• Experience with AWS RDS.
• Ability to automate regular processes and document changes.

Key Skills

Education

Any Gradute