Source description
About the role
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. Job Category: MySQL or C# Oracle PostgreSQL Python SQL Server Job Type: Full Time Job Location: Maharashtra Pune Country: India Experince: 5
More at Metaforge IT Solutions