DB Lead

Job Description:

• We are seeking a highly motivated and experienced DB Lead with a strong background in MYSQL/Oracle and technical leadership to join our dynamic team.
• The ideal candidate will have around 8+ years of experience in the IT industry, including extensive hands-on knowledge of the MYSQL/Oracle and expertise in Python and Pyspark along with AWS.

Key Responsibilities:

Roles & Responsibility

• Database Design and Architecture: Lead the design, implementation, and optimization of scalable and efficient database architectures to support business requirements.
• Data Modeling and Management: Develop data models, database schemas, and data pipelines for efficient storage, retrieval, and management of data across platforms.
• AWS Database Services: Manage AWS databases, including Aurora (PostgreSQL/MySQL) and DynamoDB, optimizing for cost, performance, and scalability.
• Python Scripting: Use Python for data manipulation, automation of database tasks, and integration with other systems.
• Database Performance Optimization: Monitor and optimize database performance, troubleshoot issues, and ensure high availability and disaster recovery.
• Documentation and Reporting: Maintain up-to-date documentation for database architectures, processes, and configurations. Generate reports on database performance, issues, and improvements.

Primary Skills (Essential):

• At least five years of professional programming experience writing performant stored procedures/functions/SQL statements
• Database Management: Expertise in database administration, tuning, and troubleshooting.
• SQL Expertise: Strong SQL skills across various database systems.
• AWS Databases: Proficiency with Amazon Aurora (MySQL/PostgreSQL) and DynamoDB, including setup, optimization, and scaling.
• Python: Strong Python skills for data manipulation, automation, and database task management.
• Data Modeling: Proficiency in designing logical and physical data models to support business processes.

Secondary Skills (Highly Beneficial):

• Snowflake: Hands-on experience with Snowflake data warehousing, data modeling, and data ingestion processes.
• ETL/ELT Tools: Familiarity with ETL/ELT processes and tools (e.g., Apache Airflow, AWS Glue) for data transformation and ingestion.
• Data Governance and Compliance: Knowledge of data governance practices, including data security and regulatory compliance standards.

Required Skills and Qualifications:

• Experience: Around 8 years of overall IT experience, with at least 5 years focused on MYSQL/Oracle and 2+ years in AWS.
• Technical Skills: In-depth knowledge of the MYSQL/Oracle, including Python, Pyspark, and Data Modeling.
• Experience with AWS
• Leadership Skills: Excellent communication, presentation, and interpersonal skills. Ability to manage multiple presales opportunities simultaneously and work in a fast-paced environme
• We are seeking a highly motivated and experienced DB Lead with a strong background in Python and technical leadership to join our dynamic team.
• The ideal candidate will have around 8 years of experience in the IT industry, including extensive hands-on knowledge of the MYSQL/Oracle and expertise in Python .

Who We Are and What We Do

Aspire Systems is a global technology services firm serving as a trusted technology partner for more than 250 customers across the globe. Aspire works with the worlds most innovative enterprises in Banking, Insurance, Retail and ISVs, helping them leverage technology to transform their business in the current digital landscape. Aspire s proven approach to Software Engineering & Digital Technologies helps companies run smart business models. Aspire s core philosophy of Attention. Always. communicates its belief in lavishing care and attention to its customers and employees.