Consultant - Database Administrator Job in Affine Transformation

Job Description Technical Skills: Database Management Systems (DBMS): Proficiency in working with various DBMS platforms such as Microsoft SQL Server, Oracle, MySQL, PostgreSQL, MongoDB, etc. Database Design: Ability to design and implement database structures, including tables, schemas, indexes, and constraints, while adhering to best practices. Database Administration: Experience in performing database installation, configuration, maintenance, backup, recovery, and security management. SQL (Structured Query Language): Strong command of SQL for querying databases, writing stored procedures, triggers, and optimizing SQL queries. Performance Tuning: Skills in identifying and resolving database performance issues by optimizing queries, indexing, and system configurations. Data Modeling: Proficiency in data modeling techniques, including Entity-Relationship Diagrams (ERDs), to design efficient and effective database schemas. ETL (Extract, Transform, Load): Knowledge of ETL processes and tools for data extraction, transformation, and loading into databases. Data Backup and Recovery: Expertise in developing and implementing data backup and recovery strategies to ensure data availability and integrity. Security and Compliance: Understanding of database security measures, access control, encryption, and compliance with industry standards and regulations (e.g., GDPR, HIPAA). Database Monitoring: Experience with database monitoring tools to track performance metrics, identify bottlenecks, and proactively address issues. Analytical Skills: Data Analysis: Proficient in using data analysis tools and techniques to extract meaningful insights from databases. Data Quality Management: Ability to assess and improve data quality through validation, cleansing, and data profiling. Query Optimization: Skill in optimizing SQL queries to retrieve data efficiently and generate reports. Reporting Tools: Familiarity with reporting tools like Tableau, Power BI, or Crystal Reports for creating data visualizations and dashboards.