Job
Description
Creative Technosoft System Pvt. Ltd. is seeking an experienced Senior SQL Database Administrator with over 5 + years of expertise in SQL, SQLite, Hadoop, and Big Data technologies . Proficiency in Python scripting is preferable to automate and optimize database operations. Preference will be given to candidates who are immediate joiners . The ideal candidate will be adept at managing, maintaining, and optimizing databases while collaborating with cross-functional teams to ensure data availability, integrity, and scalability. Responsibilities: Database Administration: Oversee the design, implementation, maintenance, and performance optimization of the applications’ SQL and SQLite databases . Big Data Expertise: Hands-on experience with Hadoop and other Big Data technologies to manage, process, optimize, and troubleshoot large datasets and distributed systems. Automation and Scripting: Develop and maintain automation scripts using Python to streamline routine database management tasks. Performance Tuning: Monitor and analyze database performance, identifying and resolving bottlenecks, slow queries, and other performance issues to ensure optimal system responsiveness. High Availability and Disaster Recovery: Implement and maintain high availability (HA) and disaster recovery (DR) solutions, such as clustering, mirroring, and AlwaysOn, to ensure data integrity and minimize downtime. Security and Compliance: Implement and enforce robust security measures to protect sensitive data, ensure compliance with industry regulations, and regularly conduct security audits. Backup and Recovery: Develop and maintain backup and recovery strategies to safeguard critical data, perform routine backups, and manage recovery processes. Capacity Planning: Monitor database growth trends and plan for capacity expansion, including provisioning and scaling of resources as needed. Database Upgrades and Migrations: Plan and execute upgrades, patches, and migrations of database systems while minimizing disruptions to operations. Troubleshooting: Investigate Show more Show less
