Database Administrator

Ibusiness Funding - Fort Lauderdale, FL

Full-time - Mid Level

Fort Lauderdale, FL

About the position

The Database Administrator at iBusiness Funding will play a crucial role in designing, deploying, and optimizing scalable and reliable database solutions within the AWS environment. This position is focused on managing and optimizing databases to ensure their security, availability, and performance, while enabling data-driven solutions for internal and external clients. The role requires collaboration with various teams to select optimal database technologies and enforce best practices in database management.

Responsibilities

• Implement scalable, highly available database solutions utilizing AWS native services (RDS, DynamoDB, Aurora, and Redshift).
• Utilize AWS tools and other 3rd party services to optimize cloud database infrastructure.
• Collaborate with developers and business/operations teams to select optimal database technologies based on application requirements.
• Define and enforce database standards, best practices, and security protocols.
• Perform regular database administration tasks, including backups, restores, patching, and upgrades.
• Proactively monitor database performance, identify bottlenecks, and implement tuning strategies for best performance.
• Diagnose and resolve complex database issues in a timely and efficient manner.
• Create and maintain comprehensive documentation for troubleshooting and knowledge transfer.
• Automate routine database management tasks utilizing scripting and AWS tools.
• Work closely with development teams, systems engineers, and stakeholders to understand data requirements and optimize database usage.

Requirements

• Bachelor's degree in Computer Science, Engineering, Mathematics, or a related technical discipline.
• Experience working with large-scale data repositories like data lakes or dimensional data warehouses.
• In-depth understanding of cloud database design principles and best practices within AWS.
• Solid understanding of database querying, performance tuning, replication, caching strategies, and sharding concepts.
• Ability to write high quality, maintainable, and robust code, often in SQL and Python.
• Experience managing multiple RDS Clusters on a variety of DB engines.
• Strong AWS DBA expertise in relational (RDS, Aurora) and/or NoSQL (DynamoDB) database technologies.
• 4-6 years of AWS DBA experience required.
• Experience with Amazon Athena, Lake Formation, AWS Glue, AWS Data Migration Service.
• Experience working with software engineers on implementing ORM libraries, such as Prisma and Alembic.
• Extensive experience dealing with PII data abiding by industry standards and regulations, and implementing controls such as column level permissions, data-masking, and logging and monitoring.

Nice-to-haves

• 5+ Years of Data Warehouse Experience with Oracle, Redshift, Postgres, Snowflake etc. with demonstrated strength in SQL, Python, data modeling, ETL development, and data warehousing.
• Familiarity with OpenSearch, ElastiCache/Redis.
• AWS certifications (AWS Certified Database - Specialty, AWS Certified Solutions Architect).
• Knowledge of infrastructure-as-code tools (Cloud Formation).
• Understanding of DevOps principles and methodologies.
• Fundamental understanding of version control software such as Git.
• Experience with CI/CD, automated testing, and DevOps best practices.
• Familiarity with data visualization tools such as Quicksight, Tableau, PowerBI.
• Experience with technical requirements for data classification and implementing data protection technologies.
• Extensive experience working with cloud services (AWS or Azure or GCS) with a strong understanding of cloud databases (e.g. Redshift/Aurora/DynamoDB), compute engines (e.g. EMR/EC2), data streaming (e.g. Kinesis), storage (e.g. S3).