Sr. Database Engineer/Administrator

• Design and develop database schemas, objects (tables, views, stored procedures, and triggers), and ETL pipelines to support On Premise and Cloud based applications.
• Develop and maintain integration processes between on-premises databases, and AWS cloud platforms.
• Create and optimize SQL queries, scripts, and code for data manipulation and reporting.
• Leverage Data Loader, APIs, or similar tools for data imports, exports, and migrations.
• Develop data models that support development, business intelligence (BI) and analytics initiatives.
• Analyze database issues and troubleshoot or configure the database accordingly
• Drive automation of code
• Monitor database performance to ensure high levels of security and speed

Database Administration

• Manage and maintain Cloud-based databases (e.g. SQL Server Database, MySQL, Aurora DB, Redshift) and hybrid environments.
• Monitor and optimize database performance, ensuring high availability and security.
• Implement backup, recovery, and disaster recovery solutions for Cloud-hosted and on-premises databases.
• Administer and optimize databases and data integrations.
• Apply updates, patches, and manage database upgrades in cloud and on-prem environments.
• Assist in the design and implementation of cloud-based data warehousing solutions.

Performance Optimization

• Analyze and optimize database performance using indexing strategies, query tuning, and partitioning techniques.
• Troubleshoot and resolve complex database issues, ensuring minimal downtime.
• Monitor system performance and usage patterns to plan for future scalability.

Data Governance and Compliance

• Enforce data security, privacy, and compliance with relevant regulations (e.g., PCI, NIST, GDPR).
• Implement and maintain role-based access controls in On Premise and Cloud environments.
• Establish and document database development and administration standards.

Collaboration and Support

• Partner with Stem Engineers, architects, and key stakeholders to deliver robust solutions.
• Provide technical support to end-users and resolve database-related issues.
• Train team members on database tools, processes, and best practices.

Qualifications:

• Bachelor’s degree in computer science or a related field.
• 8-11 years of experience in database administration, information technology, database architecture, or a related field.
• Experience with MySQL/Postgres/Aurora/MSSQL server tuning, query optimization, replication strategies, storage engines, monitoring, capacity planning, backups, recovery, HA, Clustering, etc.
• Ability to develop procedures, processes, and conventions to standardize database operations.
• Proficient in one of the scripting languages (Shell, Perl, PHP, Python etc.) for monitoring and custom automation.
• Good understanding of relational and dimensional data modeling