Still Struggling with Tech Hiring? Discover Olibr's Solution Now!

Cloud Database Architect|Pune|11+Yrs

  • Right Move Staffing Solutions Private Limited
  • India, P...
  • 11 - 15 Yrs

Job Description

  • Bachelor"s or Master"s degree in computer science, information technology, or a related field.
  • Proven work experience as a Database Architect or a similar role.
  • In-depth knowledge of database management systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL) and related technologies.
  • Proficiency in database design principles, data modeling, and normalization techniques.
  • Strong SQL programming skills and experience with query optimization.
  • Familiarity with data integration and ETL (Extract, Transform, Load) processes.
  • Knowledge of database security principles and best practices.
  • Experience with performance monitoring and tuning tools.
  • Excellent problem-solving and analytical skills.

Job Responsibilities

  • Database Design: Design and develop database architectures, including conceptual, logical, and physical models, to meet our needs. Evaluate and select appropriate database technologies, considering factors such as performance, scalability, and cost-effectiveness.
  • Database Development: Create and modify database objects, such as tables, views, stored procedures, and triggers. Write efficient and optimized SQL queries and optimize database performance through indexing, query tuning, and database parameter configuration.
  • Data Integration: Design and implement strategies for data integration, data migration, and data synchronization between various systems and databases. Ensure smooth data flow and integrity across different platforms and applications.
  • Data Security and Privacy: Implement robust security measures to protect sensitive data and ensure compliance with relevant regulations (e.g. , GDPR, HIPAA). Define and enforce access controls, authentication mechanisms, and data encryption techniques.
  • Performance Optimization: Monitor and analyze database performance metrics, identify bottlenecks, and implement performance tuning techniques. Conduct regular database capacity planning and scalability assessments.
  • Backup and Recovery: Develop and implement backup and recovery strategies to ensure data availability and minimize downtime. Perform regular backups, test recovery procedures, and maintain disaster recovery plans.
  • Data Governance: Establish and enforce data governance policies and procedures to maintain data quality, consistency, and standardization across the organization. Define and implement data management best practices.
  • Collaboration and Communication: Collaborate with cross-functional teams, including developers, system administrators, and data analysts, to understand their requirements and provide guidance on database-related matters. Effectively communicate complex technical concepts to non-technical stakeholders.
  • Documentation and Training: Create and maintain comprehensive documentation, including database schemas, data dictionaries, and technical specifications. Conduct training sessions to educate users and developers on database-related topics.

Location

Pune, Maharashtra, India