• Monitor overall SQL Server health, performance, and availability on a daily basis • Proactively identify and resolve SQL Server issues before they cause system outages • Manage and monitor SQL Agent Jobs and Maintenance Plans, ensuring they execute successfully • Review and maintain SQL Server error logs, event logs, and system alerts • Perform regular database integrity checks, index maintenance, and statistics updates • Ensure adequate disk space, memory, and CPU resource allocation for SQL Server instances • Manage and monitor SQL Server replication (transactional, merge, or snapshot as applicable) • Troubleshoot and resolve replication errors and latency issues promptly • Document replication topology, subscriber/publisher configurations, and recovery procedures • Implement alerts for replication failures with escalation procedures to prevent business downtime • Serve as the SQL SME (Subject Matter Expert) for the CounterPoint point-of-sale platform • Coordinate with CounterPoint support teams on SQL-related issues and escalations • Investigate and resolve database issues that cause CounterPoint instability or non-functionality • Maintain documentation of CounterPoint database schema, stored procedures, and custom objects • Design, implement, and verify robust SQL Server backup strategies (full, differential, transaction log) • Test and document database restore procedures regularly • Maintain and enforce Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO) • Ensure backup jobs are monitored and completed successfully; respond to backup failures immediately • Manage SQL Server logins, roles, and permissions following least-privilege principles • Conduct periodic security audits of database access and permissions • Apply SQL Server service packs, cumulative updates, and security patches on a regular schedule • Maintain compliance with internal data governance and security policies • Document all existing SQL Server configurations, Agent Jobs, Maintenance Plans, and replication setups • Establish and maintain a SQL Server runbook and standard operating procedures (SOPs) • Recommend and implement improvements to database architecture, performance, and reliability • Provide regular status reports on SQL Server health to IT management

• Maintain all enterprise SQL database operations including SQL server updates and patches • Maintain database security and compliance with company, industry and government standards (GDPR, HIPAA, etc.) • Review current architecture and updates and optimizes all the firm's enterprise database systems • Architect and implement new database systems • Proactively monitor database performance and perform database tuning for optimal performance • Troubleshoot enterprise database servers and related systems • Support system audits and provide documentation as required • Plan testing and implementation of DR and backup processes to ensure continuous operation • Create custom queries, data-driven SSRS subscriptions, migration scripts, and execute other tasks as needed

• 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.