• Will be responsible for providing all activities related to the administration of computerized databases. • Project long-range requirements for database administration and design in conjunction with other managers in the information systems function. • Design, create, and maintain databases in a client/server environment. • Conduct quality control and auditing of databases in a client/server environment to ensure accurate and appropriate use of data. • Advise users on access to various client/server databases. • Design, implement, and maintain complex databases with respect to JCL, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. • Apply knowledge and experience with database technologies, development methodologies, and front-end/back-end programming languages (e.g., SQL). • Perform database programming and supports systems design. • Provide maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems through database design.

Role Description - Database Operations and Reliability: - Design, implement, and manage robust High Availability (HA) and Disaster Recovery (DR) solutions (e.g., Replication, Always On Failover Clusters, Log Shipping) to ensure minimal downtime and data loss. - Have experience for and responsible for migrations of database servers including Mysql 5+ to newer, MariaDB 10+ to newer, MSSQL SQL Server 2016+ to newer versions while maintaining continuity for stored procedures, ETLS, applications, and role-based access for both Microsoft and non-Microsoft identities. - Participate and assist with implementation of policies for role-based access as well as transition plans for changes in access methodologies. - Proactively monitor database performance, identify bottlenecks, and execute expert-level query, index, and server-level tuning to optimize application responsiveness and resource utilization. - Implement and maintain comprehensive monitoring and alerting systems to proactively detect and resolve performance degradation, capacity issues, and system failures. - Plan, test, and execute regular database patching, version upgrades, and maintenance tasks (backups, integrity checks) during scheduled maintenance windows, including documentation, standardization, and audits. - Technical Expertise and Environment: - Serve as a subject matter expert for SQL Server and MySQL database environments, with familiarity managing MongoDB clusters. - Manage, deploy, and administer databases on cloud platforms, specifically utilizing services within AWS (e.g., RDS, EC2-hosted instances) and Azure (e.g., Azure SQL Database, VMs). - Implement and enforce security best practices, including user access management, encryption, auditing, and compliance with industry standards. - Manage database storage needs, plan for capacity scaling, and optimize resource allocation in the cloud to control costs. - Collaboration and Automation: - Partner closely with Software Engineering, DevOps, Infrastructure, and Security teams to provide database design input, troubleshoot application-related database issues, and integrate security policies. - Develop and maintain scripts (PowerShell, Python, or Shell) to automate routine operational tasks, reporting, and deployment processes. - Work with Infrastructure-as-Code (IaC) tools (e.g., Terraform, Ansible) to deploy and configure database infrastructure in an automated, repeatable manner. Qualifications - 5+ years of hands-on experience as an Operational or Production DBA. - Deep knowledge of SQL Server and MySQL architecture, internals, and advanced features (HA/DR, replication, security). Being strong in both is required. - Proven experience administering databases hosted on either AWS or Azure (experience with both is highly preferred). - Demonstrated commitment to participating in a 24/7 on-call rotation and responding to critical incidents outside of regular business hours. - Expert proficiency in T-SQL and/or PL/SQL and strong scripting capabilities (PowerShell, Python, or Bash). - Excellent problem-solving, analytical, and communication skills to clearly articulate technical issues to both technical and non-technical stakeholders. Requirements - Experience managing databases via Infrastructure-as-Code (IaC) tools like Terraform or Ansible. - Familiarity with NoSQL databases, specifically operational experience with MongoDB. - Relevant industry certifications (e.g., AWS Certified Database - Specialty, Microsoft Certified: Azure Database Administrator Associate). - Experience in optimizing database deployments for microservices architectures. Benefits - Night Shift allowance as per process - Health Insurance - Tuition Reimbursement - Work Life Balance Initiatives - Rewards & Recognition - Internal movement through IJP

Role Description We are looking for a highly experienced Oracle Property Graph Database Specialist with 7–10+ years of experience in Oracle technologies and advanced data modeling. The ideal candidate will be responsible for designing and implementing graph-based data models aligned with complex network architectures. This role requires deep expertise in Oracle Database along with hands-on experience in graph technologies to enable relationship-driven analysis, network insights, and high-performance data processing. Key Responsibilities - Design and develop scalable graph data models (nodes, edges, properties) based on network architecture and system relationships - Implement and manage Oracle Property Graph solutions within the Oracle Database ecosystem - Convert relational and network data into graph structures for advanced analytics - Develop and optimize graph queries using PGQL (Property Graph Query Language) - Analyze and interpret network topology, connectivity, and dependencies using graph techniques - Collaborate with data architects, DBAs, and application teams to integrate graph solutions - Ensure performance tuning, scalability, and efficient data processing for large graph datasets - Support data migration, transformation, and validation processes - Provide technical guidance and best practices for graph-based implementations Qualifications - 7–10+ years of strong experience in Oracle Database development and administration - Hands-on experience with Oracle Property Graph and related tools (Graph Server, Graph Studio) - Strong expertise in SQL, PL/SQL, and Oracle data architecture - Proven experience in data modeling, including translating relational models into graph models - Experience working with network-based data structures (telecom, infrastructure, or similar domains) - Strong understanding of graph concepts such as traversal, pathfinding, and relationship analysis - Ability to design efficient and scalable graph schemas Salary Best market rate

• Data Pipeline Execution (ETL): Build, manage, and monitor efficient ETL/ELT pipelines to consolidate data from multiple production AWS PostgreSQL instances into Snowflake for analytics and reporting. • Advanced Query Auditing & Performance Tuning: Continuously audit SQL queries across our production systems. Diagnose complex bottlenecks, rewrite sub-optimal queries, optimize indexes, and tune database configurations to ensure peak platform speeds. • Database Operations & Maintenance: Oversee the day-to-day health, backup strategies, security compliance, and scaling of our PostgreSQL (AWS RDS/Aurora) and Snowflake environments. • Query Best Practices & Collaboration: Partner with Software Engineers to review database schemas and queries before they hit production, acting as a trusted advisor on SQL best practices. • Troubleshooting & Optimization: Serve as the senior escalation point for database performance issues, ensuring minimal downtime and high availability for our core SMS services.