Database Specialist

As a Database Specialist, you will play a pivotal role in designing and developing efficient databases that support an organization's data management needs. You will collaborate with cross-functional teams to ensure data integrity, performance, and reliability. This position requires a deep understanding of database technologies, strong analytical skills, and a passion for developing and optimizing data storage and retrieval processes.

• Database Design and Development:
  • Analyze and understand business requirements to design, develop, and implement appropriate database solutions.
  • Create and optimize database schemas, tables, views, and stored procedures for efficient data storage and retrieval.
  • Collaborate with software developers to integrate database components into applications, ensuring seamless functionality.
• Data Modeling and Optimization:
  • Develop and maintain data models representing the organization's data structure and relationships.
  • Identify and implement performance optimization techniques like indexing, query optimization, and caching mechanisms.
  • Monitor and analyze database performance metrics to identify bottlenecks and recommend improvements.
• Database Administration:
  • Install, configure, and upgrade database management systems (DBMS) and associated tools.
  • Monitor database systems to ensure optimal performance, availability, and reliability.
  • Troubleshoot and resolve database-related issues, including performance bottlenecks, data corruption, and system failures.
• Collaboration and Documentation:
  • Collaborate with cross-functional teams to gather requirements, provide technical guidance, and support data-related initiatives.
  • Document database designs, configurations, and troubleshooting procedures for future reference.
  • Stay updated with emerging trends and technologies in database management and propose innovative solutions to enhance data management processes.

• Strong knowledge of SQL, NoSQL, relational database, and Data Warehouse management systems.
• Familiarity with data modeling and database design principles.
• Good problem-solving and analytical skills.
• Effective communication and collaboration skills to work within cross-functional teams.
• Ability to handle multiple tasks and prioritize effectively in a fast-paced environment.

• Good understanding of ITIL Foundation or preferably certified. Database certifications are a plus.
• Excellent verbal and written communication skills, customer focus, and ability to work with both technical and non-technical people.
• Strong attention to detail and analytical thinking in resolving problems and documenting solutions.

• Designing database structures and tables.
• Creating database automation.
• Optimizing SQL queries to integrate with applications.
• Developing functions, views, and stored procedures.