• Drive high availability and disaster recovery strategies, ensuring RPO/RTO targets are met for core banking systems • Define and execute the scalability roadmap, including partitioning, sharding strategies, and capacity forecasting • Perform deep-dive query optimization, execution plan analysis, and proactive bottleneck remediation • Build and manage scalable inference and connection pooling strategies (PgBouncer) and robust backup/restore automations • Design the monitoring architecture (Prometheus, Grafana, VictoriaMetrics) and define SLIs/SLOs for database health • Implement banking-grade security practices, including credential management and compliance-aligned data handling • Work with product teams to ensure database schema changes and architectural decisions support a high-load environment • Set the technical bar for the DBA function through mentoring, standards definition, and hands-on implementation

Title: Data/Database Administration Location:San Francisco, CA Job Code:300125 Description: Mastech Digital provides digital and mainstream technology staff as well as Digital Transformation Services for all American Corporations. We are currently seeking a Data/Database Administrator for our client in the Professional Services domain. We value our professionals, providing comprehensive benefits and the opportunity for growth. This is a Contract position, and the client is looking for someone to start immediately. Duration: 12+ Months Contract Location: Remote Salary: $55.00-$65.00/Hourly Role: Data/Database Administration Primary Skills: Data Analysis Role Description: The Data/Database Administrator must have 6+ years of experience. We are seeking a Workforce Analytics and AI Manager to support the client’s Corporate Services and Gen AI offerings. This position will be part of the Advisory Digital team and will focus on delivering innovative solutions, research, and insights for key clients through data, analytics, and AI. Responsibilities: - Collaborate strategically with senior leadership within the firm to translate business needs into data, analytics, and AI requirements. - Lead a small, high-performing team (both on-shore and off-shore) to ensure quality and timely delivery of various use cases. - Develop and refine data models and analyses to generate benchmarks, actionable insights, and recommendations, leveraging third-party data to support go-to-market efforts and delivery model transformation. - Conduct in-depth market, industry, and competitive research, translating findings into strategic insights, reports, and thought leadership content. - Foster and maintain relationships with executive leadership to ensure critical strategic staffing, budgeting, data, and analytic needs are appropriately addressed. - Support the maturation of the program by identifying areas for process improvement and contributing to strategic internal/structuring improvement projects. Qualifications: - 5+ years of recent experience related to strategic program management, data analysis, corporate strategy, or applied analytics, preferably within a consulting context. - Bachelor's degree from an accredited university; Master's degree and/or certifications are a plus. - Experience identifying opportunities for advanced analytics use cases, building use cases to prove out value and justify investment, and using data to convey findings to various audiences (C-suite, government agencies, white papers, etc.), and analytical and BI tools like Alteryx, Power BI. - Demonstrated ability to engage and partner with senior stakeholders across a large organization, with strong analytical, creative problem-solving, and decision-making skills. - Ability to thrive in a fast-paced setting, managing various stakeholders and use cases concurrently across diverse industries and client service portfolios, and overseeing daily operations of a small data and analytics team, offering prompt feedback for staff development within the firm. - Excellent interpersonal, written, and verbal communication skills; demonstrated ability to develop strong relationships with and effectively communicate complex ideas to technical and non-technical audiences across all levels of the organization. Education: Bachelor’s degree Experience: Minimum 6+ years of experience Relocation: This position will not cover relocation expenses Travel: No Local Preferred: Yes Note: Must be able to work on a W2 basis (No C2C) Recruiter Name: Kajal Vatsa Recruiter Phone: 484-331-9666 Benefits: We have various coverages and additional benefits to choose from: - Medical, Dental (Including Ortho) & Vision Insurance (Option to Enroll). - Paid Leaves (Wherever applicable). - Life & Disability Coverage (Upon eligibility). - 401K Option, Education Assistance Program and more. Mastech Digital is an Equal Opportunity Employer - All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Title: Database Developer - Extract, Transform, and Load Location: Smithfield, RI Job Code:301977 Description: Mastech Digital provides digital and mainstream technology staff as well as Digital Transformation Services for all American Corporations. We are currently seeking a Database Developer/ETL for our client in the Financial Services domain. We value our professionals, providing comprehensive benefits and the opportunity for growth. This is a Contract position, and the client is looking for someone to start immediately. Duration: 12+ Months Contract (possible extension/ conversion) Location: Smithfield, RI (Hybrid) 2 weeks onsite per month/ alternate weeks, rest remote Salary: Up to $130,000/Annually or $65.00/Hourly Role: Database Developer/ETL Primary Skills: Database Development Role Description: The Database Developer/ETL must have 5+ years of experience. Primary Responsibilities: - Database Development, primarily in Oracle PL/SQL. - Must be strong in writing Complex Queries. - Writing PL/SQL functions and packages. - The ability to Diagnose data issues and performance matrix; ETL, specifically Informatica, experience also strongly preferred. Must Haves: - PL/SQL - Expert - ETL - Informatica - Oracle - Expert - Development background - Packaging - Expert Nice To Have Skills: - Enterprise Data Lake experience - Modeling nice to Have - Financial background - Cloud exposure The Skills that are Key to this role: - Demonstrative experience in Oracle/ PL-SQL and Informatica ETL including packages, procedures, function, and triggers. - Ability to optimize sophisticated queries and compose efficient solutions. - Experience working in enterprise environments with version control and deployment standards. - Excellent Analytical and problem-solving skills with detail-oriented mindset. - Extensive experience in Data engineering, Data modeling and Data analysis - Experience in ETL invent and development. - Experience with data base such as Oracle (Primary), SQL server. - Experience of working in Agile methodology. - Knowledge of Containerization and cloud deployment related to Database. - Ability to build communication and rapport with partners and stakeholders. - Ability to adapt, in a changing environment and be effective in many different business settings. - Ability to take initiative, define vision for improvement of products, and execute at high level of quality The skills that are good to have for this role: - Ability to plan and work with geographically spread-out teams - Strong presentation and interpersonal skills. - Curiosity to constantly relearn/explore new processes/technologies The Value You Deliver: - Developing and crafting robust high per-performance database solutions. - Assessing and researching current implementations of the platform and determining the course of action required to elevate the platform to meet customer needs. - Taking the business requirements coupled with existing architecture to set a technical vision for features and major components and clearly articulating the evolutionary steps to achieve it. Education: Bachelor’s degree Experience: Minimum 5+ years of experience Relocation: This position will not cover relocation expenses Travel: No Local Preferred: Yes Note: Must be able to work on a W2 basis (No C2C) Benefits: We have various coverages and additional benefits to choose from: - Medical, Dental (Including Ortho) & Vision Insurance (Option to Enroll). - Paid Leaves (Wherever applicable). - Life & Disability Coverage (Upon eligibility). - 401K Option, Education Assistance Program and more. Mastech Digital is an Equal Opportunity Employer - All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

• Administer and manage Oracle databases on Exadata infrastructure (ExaCC / on-premise) and Linux-hosted Standard Edition environments. • Monitor database health, availability, and capacity across multiple hosted customer environments. • Manage Oracle RAC (Real Application Clusters) and Data Guard configurations on Exadata. • Coordinate planned maintenance, failover testing, and disaster recovery activities. • Manage ASM (Automatic Storage Management) diskgroups and storage configurations on Exadata. • Conduct proactive and reactive performance analysis using AWR, ADDM, ASH, and Statspack reports. • Identify and resolve database bottlenecks related to SQL execution plans, memory allocation (SGA/PGA), I/O, and locking contention. • Tune SQL statements, indexes, and schema objects to improve application response times. • Provide written performance improvement recommendations and root cause analysis to stakeholders and customers. • Monitor and tune Exadata-specific features: Smart Scan offloading, Flash Cache, Hybrid Columnar Compression (HCC), and IORM. • Plan and execute Oracle quarterly PSU/RU patching for Standard Edition databases on Linux. • Manage full-stack patching on Exadata platform, including DB home patches, GI patches, Exadata Bundle Patches (ExaBP), and cell patches. • Coordinate patching activities through the Change Advisory Board (CAB) process, ensuring minimal customer downtime. • Test patches in lower environments prior to production rollout and maintain detailed patching runbooks. • Track Oracle patch schedules, Critical Patch Updates (CPUs), and security advisories. • Develop and maintain Shell (Bash), Python, and PL/SQL scripts to automate routine DBA tasks including health checks, space monitoring, alert log parsing, and report generation. • Build and enhance automation for patching workflows, backup verification, and performance data collection. • Integrate DBA automation scripts with CI/CD pipelines (Azure DevOps, GitHub Actions) where applicable. • Contribute to Infrastructure as Code (IaC) initiatives related to database provisioning and configuration management. • Design, implement, and maintain Oracle RMAN backup strategies for Exadata and SE environments, including full, incremental, and archived log backup policies. • Perform and validate periodic recovery tests to confirm backup integrity and meet RTO/RPO objectives. • Manage Data Pump (expdp/impdp) exports for logical backups, environment refreshes, and data migration. • Maintain backup and recovery runbooks, escalation procedures, and incident documentation. • Respond to and lead database recovery efforts during incidents, ensuring minimal data loss and rapid restoration. • Partner with application teams, infrastructure engineers, and customer success managers to resolve database-related issues. • Contribute to internal knowledge base and Confluence documentation for SOPs, runbooks, and architecture references. • Participate in on-call rotation to support production databases during off-hours incidents. • Mentor junior DBA team members and provide technical guidance on best practices.