ICT Architect – Database
- Full time
- Noida IN
- @Ericsson
Job Detail
-
Job ID 2286
-
Career Level Others
-
Experience 8-10 Years
-
Industry Telecommunications
-
Qualifications Degree Bachelor
Job Description
Responsibilities:
- Design and architect database solutions based on business requirements, performance considerations, and scalability needs.
- Define database standards, guidelines, and best practices for data storage, indexing, partitioning, and optimization.
- Experience with code review and revision control software like Git, Gerrit.
- Strong experience with Linux OS.
- Working knowledge of database’s critical underlying services such as Storage/Network/Virtualization.
- Develop and maintain scripts, stored procedures, functions, triggers, and views to support application functionality and data manipulation.
- Implement database changes and enhancements in collaboration with development teams, ensuring compatibility and performance.
- Optimize database queries, indexes, and data structures for improved performance and resource utilization.
- Install, configure, and upgrade database software and related tools, ensuring compatibility, security, and reliability.
- Monitor database performance, troubleshoot issues, and implement corrective actions to minimize downtime and ensure optimal performance.
- Implement backup and recovery strategies to protect data integrity and ensure business continuity in case of system failures or disasters.
- Implement security measures to safeguard sensitive data and ensure compliance with regulatory requirements.
- Manage user access and permissions, encryption, and data masking techniques to protect data confidentiality and integrity.
- Identify and resolve performance bottlenecks, slow queries, and resource contention issues through query optimization, index tuning, and database configuration adjustments.
- Conduct performance testing and analysis to identify areas for improvement and scalability enhancements.
Qualifications:
- Proven 8+ years of experience as a Database Developer, Database Architect, or similar role in designing, developing, and managing complex database systems.
- Proficiency in database technologies such as OpenSearch, MSSQL, MySQL, PostgreSQL, MongoDB, or similar relational and NoSQL databases.
- Familiarity with database monitoring and performance tuning tools (e.g., SQL Profiler, Oracle Enterprise Manager, pgAdmin, MongoDB Compass).
- Knowledge of data integration techniques, ETL processes, and data migration strategies.