Sr. Database Developer

Job Description

     Database Design and Development:

• Design and develop database schemas, tables, views, and indexes based on application requirements.
• Write and optimize complex SQL queries and stored procedures.
• Implement data normalization and denormalization strategies to improve database performance.

    Database Maintenance and Optimization:

• Monitor database performance and implement tuning strategies  to ensure optimal efficiency.
• Regularly backup and restore databases, ensuring data integrity and availability.
• Manage database security, including user access control and data encryption.

     Collaboration and Support:

• Work closely with software developers, data analysts, and system administrators to support application development and data integration.
• Provide technical support and troubleshooting for database related issues.
• Document database design, procedures, and standards.
   

    Data Integration and Migration:

• Develop ETL (Extract, Transform, Load) processes to integrate data from various sources.
• Plan and execute data migration strategies for system upgrades or changes.
  

      Reporting and Analysis:

• Create and maintain reports and dashboards to support business analysis and decision-making.
• Analyze and interpret complex data sets to provide actionable insights.
   

     Experience & Skills Necessary for Position:

• 5+ years of experience with database design, performance tuning,optimization, data warehousing and ETL processes.
• Proficiency in SQL and database management systems (e.g., SQL Server, Oracle, MySQL, PostgreSQL).
• Proficiency with programming languages such as Python, or C# is a plus.