Database Architect

AirCod Technologies

发布 Apr 30, 2024 236 查看 Report Job

PKR. 300,000 - 550,000/Month

Key Responsibilities:

A Database Architect plays a crucial role in designing, implementing, and maintaining databases to meet the organization's data storage and retrieval needs efficiently. Their responsibilities encompass various aspects of database management, from initial planning and design to ongoing optimization and support:

1. Database Design and Architecture:

• Collaborate with stakeholders to understand business requirements and translate them into database solutions.

• Design and develop database schemas, tables, views, and indexes to optimize data storage and retrieval.

• Define data models, including conceptual, logical, and physical models, ensuring data integrity and consistency.

2. Performance Optimization:

• Analyze and optimize database performance by tuning queries, indexing strategies, and database configuration settings.

• Implement best practices for data partitioning, caching, and query optimization to enhance system performance and scalability.

3. Data Security and Compliance:

• Establish and enforce data security policies, including access controls, encryption, and data masking, to protect sensitive information.

• Ensure compliance with regulatory requirements (e.g., GDPR, HIPAA) and industry standards for data privacy and security.

4. Data Integration and Migration:

• Design and implement data integration solutions to facilitate seamless data flow between different systems and applications.

• Lead data migration projects, ensuring a smooth transition of data from legacy systems to new platforms while minimizing downtime and data loss.

5. High Availability and Disaster Recovery:

• Architect high availability (HA) and disaster recovery (DR) solutions to ensure continuous access to critical data and minimize downtime in case of system failures.

• Implement database replication, clustering, and backup strategies to achieve business continuity objectives.

6. Capacity Planning and Scalability:

• Assess current and future data storage requirements and plan database capacity accordingly.

• Design scalable database architectures that can accommodate growing volumes of data and user traffic without sacrificing performance.

7. Documentation and Knowledge Sharing:

• Document database architectures, designs, and configurations for reference and future maintenance.

• Provide guidance and training to other team members on database best practices, tools, and technologies.

8. Vendor Evaluation and Technology Assessment:

• Evaluate database technologies, tools, and vendors to identify the best-fit solutions for the organization's needs.

• Stay updated on emerging trends and innovations in database management to drive continuous improvement.

Skills and Qualifications:

• Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.

• Extensive experience (typically 5+ years) in database design, administration, and architecture.

• Proficiency in database management systems such as Oracle, SQL Server, MySQL, PostgreSQL, Greenplum, or NoSQL databases.

• Strong understanding of database principles, data modeling, normalization, and optimization techniques.

• Familiarity with cloud-based database services (e.g., AWS RDS, Azure SQL Database) and database as a service (DBaaS) offering.

• Excellent analytical, problem-solving, and communication skills.

技能

PostgreSQL Greenplum NoSQL MySQL

工作详细内容

全部职位:

1 发布

工作时间:

早班

工作类型:

全职/长期工

工作地址:

Johar Town, 拉合尔, 巴基斯坦

性别:

没有偏好

最低学历:

学士

职位等级:

资深专业人员

经验:

8年 - 12年

在之前申请:

May 31, 2024

发布日期:

Apr 30, 2024

AirCod Technologies

· 51-100 员工 - 拉合尔

关注

pAirCod Technologies is a leading multinational software house working in prominent market technologies to serve our valued clients with optimal solutions and products created to meet their business needs. At AirCod we develop efficient and responsive business models through proactive and multi-dimensional solutions. We empower enterprises with our automated framework approaches and business intelligence. AirCod is a state of the art technology oriented software house focused on quality of service, automation, efficiency, maintainability and reliability of the product. Specialties: Web Development OS Development App Development Graphic Solutions Technical Consultancy Data Scientist/p