Sr. Analyst DBA, Afiniti, Columbia, MD
Afiniti -
Columbia, MD,
US
Sr. Analyst DBA
Date Posted: 2024-05-20
Job description
About AfinitiAt Afiniti, we are a leading provider of artificial intelligence technology that elevates the customer experience by making moments of human connection more valuable. Our mission is rooted in a simple yet powerful idea: understanding patterns of human behavior enables us to predict how people will interact and create meaningful connections.Using our patented AI technology, we revolutionize the contact center industry by pairing customers with the most compatible contact center agents. By doing so, we enhance the entire customer journey, resulting in exceptional experiences and improved outcomes for all parties involved.Our transformative technology has generated billions of dollars in incremental value for our esteemed clients, which include Fortune 500 companies across diverse industries such as financial services, telecommunications, travel, and hospitality. We take pride in our global reach and impact, with our solutions being leveraged by organizations around the world.To learn more about Afiniti and the groundbreaking work we do, visit www.afiniti.com.About the roleThe DBA will be responsible for the availability, performance, integrity and security of the databases. Primarily with MySQL, Greenplum, Postgres on Linux and generally other community RDBMS/NoSQL Platforms. This role has a potential to get resource involved in the planning, design and development of the databases along with operational support and troubleshooting/resolution of any issues. The ideal candidate will work as a member of DBA team which provides 24/7 coverage to all production grade database servers to ensure 99.9% uptime.Key Responsibilities* Core responsibilities includes installation, administration, operations, support, and maintenance, monitoring & upgrading of database servers to ensure availability, security with optimal performance* Maintains quality of service by establishing and enforcing organization standards* Responsible to perform query optimization in addition to assist/reviews/feedbacks to stakeholders in writing complex queries, stored procedures/functions, views, DDL/DML script* Troubleshoot complex database issues in accurate and timely manner ensuring compliance to SLAs / OLAs* Maintain database operational, disaster recovery, backup procedures/processes to ensure continuous availability and speedy recovery* Responsible to maintain a good, healthy & friendly team environmentMinimum Qualifications* 5+ years of Database Management experience working with MYSQL, Greenplum, PostgreSQL, SQL Server or Oracle Databases, ideally in Linux environments* Computer Science or Information Technology Graduate from reputed institute* Strong working knowledge of Database platforms and its internal engine, storage & memory architecture/processes* Must be familiar with working and managing enterprise level mission critical databases with considerable size 2+ TBs* Ability to articulate the benefits and risks to a solution's feasibility, functionality, and alignment to a client's specific business needs* Strong understanding of project deployment cycle, and end-to-end project deployment, including technical documentation* Ability to work both independently and as part of a team* Should be willing to work in flexible shift timings (as per requirements)* Experience ramping quickly in a fast-moving environment.* Quick learner with strong initiative.* Excellent analytical and communication/soft skills are required* US Citizenship requiredPreferred Qualifications* Experience in managing or using MPP technologies such as Greenplum, Netezza or Teradata* Experience with Cloud platforms/technologies will be a plus* Experience in some programming language will be a plus* Experience with automation tools or with any scripting languageThis is a hybrid position, with three days on-site and two days working remotely.We believe that richness in diversity is a huge asset for Afiniti. We value both the similarities and differences in everyone who is a part of the Afiniti team. We believe that this diversity builds a stronger organization and is in keeping with the core values of our company. Our policy, therefore, is to provide equal employment opportunities for all applicants and employees without regard to race, color, religion, sex (including pregnancy, childbirth, related medical conditions, breastfeeding or reproductive health decisions), gender identity or expression, national origin, age, marital status, ancestry, physical or mental disability, sexual orientation, personal appearance, genetic information, family responsibilities, matriculation, political affiliation, military or veteran status, or any other category protected under applicable federal, state or local law. This means that we comply with all applicable human rights and employment legislation, and we do not discriminate in any aspect of employment, including recruiting, hiring, compensation, promotions, reductions in force, or terminations.