Systech Client is seeking a skilled Senior Database Developer DBA/Architect to join the team. The ideal candidate will have extensive experience in designing, developing, and maintaining efficient, scalable, and secure database systems. They will play a crucial role in determining database architecture, data storage, indexing techniques, and ensuring data integrity and security.
Key Responsibilities:
Design and develop database systems that are efficient, scalable, and secure, ensuring optimal performance and reliability.
Build new relational data models, tables, views, functions, triggers, stored procedures, and indexes to meet business requirements.
Collaborate with software developers and system administrators to ensure databases meet performance and scalability requirements.
Analyze organization's data needs, identify appropriate database systems, and design and implement database structures while ensuring data security and integrity.
Implement backend data integration and architecture, including dimensional data modeling, database design, data warehousing, and ETL development.
Perform performance tuning with Microsoft Power BI Stack experience for efficient reporting.
Lead DB migration projects (Oracle to SQL) and design and maintain High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
Design DB deployment strategies and oversee DB maintenance across environments.
Manage Windows server, including Active Directory, to ensure user access strategies are integrated with the application.
Focus on designing and maintaining data warehouses with large-scale repositories of data used for analysis and reporting.
Collaborate with data analysts and business intelligence professionals to design data models and create efficient queries for data extraction.
Design and implement solutions for managing data in the cloud, with experience in AWS RDS considered an advantage.
Ensure data security and integrity by implementing security protocols such as encryption, access controls, and data backup and recovery procedures. Implement data quality and validation rules to maintain accurate and consistent data.
Automate regular processes, track issues, and document changes to ensure efficient database management.