Database Administrators
Database administrator job in Oklahoma City, OK
Mercor is collaborating with a leading AI organization to identify experienced Database Administrators for a high-priority training and evaluation project. Freelancers will be tasked with performing a wide range of real-world database operations to support AI model development focused on SQL, systems administration, and performance optimization. This short-term contract is ideal for experts ready to bring practical, production-grade insights to frontier AI training efforts. * * * **2\. Key Responsibilities** - Design and optimize complex SQL queries using EXPLAIN plans and indexing strategies - Implement schema changes with CREATE/ALTER statements and rollback planning - Configure and validate automated backup and restoration procedures - Manage user roles and permissions following defined security policies - Export/import data between systems with validation checks and encoding integrity - Execute data quality checks and report violations with remediation scripts - Apply statistics updates, manage transaction logs, and test failover recovery - Perform compliance data extractions, patching, and system audits for enterprise use cases - Document processes and performance findings in clear, reproducible formats * * * **3\. Ideal Qualifications** - 5+ years of experience as a Database Administrator working in production environments - Expert-level SQL skills and proficiency with PostgreSQL, MySQL, and/or SQL Server - Strong background in performance tuning, security, data integrity, and schema design - Familiarity with compliance standards (e.g., SOX), data export formats, and backup tooling - Comfortable handling large datasets, interpreting execution plans, and managing database infrastructure end-to-end - Ability to produce production-quality scripts and documentation for technical audiences * * * **4\. More About the Opportunity** - Remote and asynchronous - work on your own schedule - **Expected commitment: minimum 30 hours/week** - **Project duration: ~6 weeks** * * * **5\. Compensation & Contract Terms** - $90-100/hour for U.S.-based freelancers (localized rates may vary) - Paid weekly via Stripe Connect - You'll be classified as an independent contractor * * * **6\. Application Process** - Submit your resume followed by domain expertise interview and short form * * * **7\. About Mercor** - Mercor is a talent marketplace that connects top experts with leading AI labs and research organizations. - Our investors include Benchmark, General Catalyst, Adam D'Angelo, Larry Summers, and Jack Dorsey. - Thousands of professionals across domains like law, creatives, engineering, and research have joined Mercor to work on frontier projects shaping the next era of AI.
Database Administrator, MongoDB
Database administrator job in Oklahoma City, OK
ComboCurve is a industry leading cloud-based software solution for A&D, reservoir management, and forecasting in the energy sector. Our platform empowers professionals to evaluate assets, optimize workflows, and manage reserves efficiently, all in one integrated environment.
By streamlining data integration and enhancing collaboration, we help operators, engineers, and financial teams make informed decisions faster. Trusted by top energy companies, ComboCurve delivers real-time analytics and exceptional user support, with a world-class customer experience team that responds to inquiries in under 5 minutes.
Were looking for a motivated and detail-oriented Database Administrator to help build and maintain the data systems that power our applications.
In this role, youll support our database infrastructure primarily MongoDB, with exposure to relational databases and Responsibilities data engineering workflows while learning from senior engineers and gaining experience in real-world production environments.
MongoDB ownership Design and administer replica sets and clusters (capacity planning, scaling, automation).Performance tuning: indexing strategy, query profiling, schema design, aggregation pipelines, concurrency, and connection management.Backup/restore, point-in-time recovery, and disaster recovery runbooks.Observability: Create dashboards/alerts (e.g., Atlas/Cloud Manager, Datadog) and capacity/latency SLOs.Run and verify backups/restores; maintain runbooks and checklists.Relational DB support (secondary) Administer and RDBMS (e.g., PostgreSQL or Snowflake): backups, replication, query tuning, indexing, vacuum/maintenance.Data modeling, normalization vs. denormalization, and query plan analysis.Data engineering Build and maintain ETL/ELT jobs to move data between MongoDB and relational systems.Implement change data capture, data validation, and quality checks.Development & collaboration Write utilities and automation in JavaScript/Node.js; craft complex SQL and MQL queries.Review designs with application engineers; advise on data access patterns and schema evolution.Participate in an on-call rotation and incident response; drive root-cause analysis and preventive fixes.Collaboration & communication Partner with dev teams to understand feature needs and data access patterns; translate requirements into DB tasks.Communicate clearly in standups, PRs, and docs; escalate risks early with actionable proposals.Contribute to incident response as a learner; participate in postmortems and document follow-ups.
Requirements13 years of experience working with databases.Basic understanding of MongoDB concepts such as documents, collections, and indexes.Exposure to SQL and relational databases (PostgreSQL, or Snowflake preferred).Familiarity with JavaScript/Node.js and PythonDetail-oriented, organized, and comfortable working in a collaborative engineering environment.Excellent communication skills and eagerness to learn from feedback.Bonus PointsHands-on experience with MongoDB Atlas, Datadog, or similar monitoring tools.Familiarity with ETL pipelines, data validation, or automation frameworks.Exposure to cloud platforms (GCP, or Azure).Experience writing small automation or data tools using APIs or scripting.Why Youll Love This Role· Mentorship from experienced engineers who will help you grow into a database specialist.· Opportunities to work on real production systems and learn modern data infrastructure from the inside out.· A collaborative, growth-oriented culture that encourages learning and continuous improvement.· The chance to make a meaningful impact on the reliability and performance of our platform.
PI6b92f6549e9a-31181-39180038
Informatica Database Administrator
Database administrator job in Little Rock, AR
The Informatica Administrator is responsible for the installation, configuration, monitoring, maintenance, and optimization of Informatica software tools used for data and application integration, transformation, and management. This role involves troubleshooting issues, ensuring performance, and maintaining data workflows to support business intelligence and analytics.
+ Install and/or upgrade, and configure Informatica PowerCenter, Informatica Cloud Data Integration, and related components.
+ Configure and maintain repository, domain, and services on Informatica server.
+ Set up environment-specific configurations (DEV, QA, PROD) for Informatica services.
+ Develop appropriate remediation steps for Common Vulnerabilities and Exposures (CVEs) identified by the security team and resolve them in a timely fashion.
+ Monitor and fine-tune the performance of Informatica jobs and workflows.
+ Work on optimizing the performance of the Informatica server, including memory management, query performance, and job throughput.
+ Identify, troubleshoot, and resolve issues related to Informatica sessions, workflows, and connectivity.
+ Resolve system-level issues affecting Informatica services and tools.
+ Perform regular system monitoring and ensure the health and availability of the Informatica environment.
+ Set up automated alerts for job failures, service downtimes, or performance issues.
+ Evaluate new features and capabilities of Informatica products and propose strategies for leveraging them.
+ Stay current with industry trends in data integration, cloud computing, and ETL technologies to influence the data architecture strategies.
+ Implement and manage backup and disaster recovery procedures for Informatica repositories and configurations.
+ Work closely with data engineers, developers, and other IT teams to support data integration requirements.
+ Provide support for troubleshooting and resolving technical issues related to the Informatica platform.
+ Maintain accurate documentation for system configurations, procedures, and workflows.
+ Generate reports on system performance, resource utilization, and other metrics.
+ Collaborate with data architects to design efficient, scalable cloud-based data integration architectures using IICS.
+ Evaluate and optimize current PowerCenter architectures for migration feasibility, including redesigning workflows and processes where necessary.
+ Align migration strategies with the organization's cloud adoption, data governance, and security policies.
**Minimum Qualifications**
+ Bachelor's Degree required or equivalent relevant experience. Master's Degree Preferred.
+ Dependent upon contract requirement.
+ 12+ years of experience working with progressively more complex or large-scale databases.
**Other Job Specific Skills**
+ Strong experience supporting Informatica PowerCenter, IICS, and other Informatica products.
+ Hands-on experience with database management systems such as Oracle, SQL Server, or PostgreSQL.
+ Hands-on experience with Informatica Connectors such as MySQL, PostgreSQL, JNDI, JMS, PowerExchange, S3, S3 Delta, or Amazon RedShift.
+ Experience managing Oracle RAC and Data Guard databases.
+ Knowledge of UNIX/Linux commands and shell scripting.
+ Experience with system monitoring tools and techniques.
+ Proficiency in troubleshooting and resolving Informatica issues.
+ Excellent communication and collaboration skills.
**Preferred Skills**
+ Informatica certification (e.g., Informatica PowerCenter Administrator).
+ Experience with cloud-based data integration tools e.g., Informatica Intelligent Cloud Services (IICS).
+ Familiarity with ETL processes and data warehousing concepts.
+ Hands-on experience with Oracle DBA functions in an enterprise environment.
**Compensation Ranges**
Compensation ranges for ASM Research positions vary depending on multiple factors; including but not limited to, location, skill set, level of education, certifications, client requirements, contract-specific affordability, government clearance and investigation level, and years of experience. The compensation displayed for this role is a general guideline based on these factors and is unique to each role. Monetary compensation is one component of ASM's overall compensation and benefits package for employees.
**EEO Requirements**
It is the policy of ASM that an individual's race, color, religion, sex, disability, age, sexual orientation or national origin are not and will not be considered in any personnel or management decisions. We affirm our commitment to these fundamental policies.
All recruiting, hiring, training, and promoting for all job classifications is done without regard to race, color, religion, sex, disability, or age. All decisions on employment are made to abide by the principle of equal employment.
Physical Requirements
The physical requirements described in "Knowledge, Skills and Abilities" above are representative of those which must be met by an employee to successfully perform the primary functions of this job. (For example, "light office duties' or "lifting up to 50 pounds" or "some travel" required.) Reasonable accommodations may be made to enable individuals with qualifying disabilities, who are otherwise qualified, to perform the primary functions.
**Disclaimer**
The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.
$120,100 - $183k
EEO Requirements
It is the policy of ASM that an individual's race, color, religion, sex, disability, age, gender identity, veteran status, sexual orientation or national origin are not and will not be considered in any personnel or management decisions. We affirm our commitment to these fundamental policies.
All recruiting, hiring, training, and promoting for all job classifications is done without regard to race, color, religion, sex, veteran status, disability, gender identity, or age. All decisions on employment are made to abide by the principle of equal employment.
Database Administrator - II, Senior, or Lead
Database administrator job in Little Rock, AR
Southwest Power Pool (SPP) is about more than power. We're about the power of relationships. Our employees have the opportunity to work together to ensure electricity is delivered reliably and affordably to the millions of people living in our service territory. We have been voted one of Arkansas' Best Places to work by Arkansas Business and we are looking for a member of our team who is passionate about our mission to keep the lights on!
We have a core ideology here at SPP that we stand by: Do the right thing, for the right reason, in the right way.
We believe in supporting our employees through a fantastic benefits package:
Competitive and transparent pay with bonus opportunities
Excellent insurance package including three great medical plans to choose from, employer-paid short-term disability, long-term disability, and life insurance
Relocation bonus (if applicable)
Hybrid working environment for positions that are eligible
Fantastic contributions to your retirement through a 401(k) savings plan with employer-match benefits and a pension (defined benefit plan) fully funded by SPP
COMPENSATION INFORMATION
The salary range(s) represents our good faith estimate for the role at this time. While we strive to provide competitive and transparent compensation, there may be circumstances where an offer is above or outside of the listed range. We are open to discussing salary expectations with qualified candidates considering factors such as the candidate's qualifications, skills, competencies, experience and geographic location will all be considered during the hiring process.
Lead Database Administrator Pay Range: $109,500.00 - $142,250.00
Senior Database Administrator Pay Range: $95,200.00 - $123,700.00
Database Administrator II Pay Range: $76,000.00 - $96,900.00
Join Our Team as a Database Administrator Team!
We're currently seeking talented individuals to join our Database Administration Team to support the mission-critical systems that keep the power grid running reliably across the central United States. Whether you're a seasoned expert or building on your DBA career, Southwest Power Pool (SPP) offers a collaborative environment, exciting technical challenges, and the opportunity to make a real impact.
Database Administrator Opportunities - Multiple Openings at All Levels
Lead Database Administrator
As a Lead DBA, you'll guide the design, installation, upgrade, and optimization of our database environments. You'll drive best practices, lead large-scale initiatives, and collaborate across teams to ensure the health and performance of our mission-critical data systems. This role also supports strategic planning and may represent SPP at external technical committees, including NERC working groups.
What You'll Do:
Lead the design and architecture of enterprise-level database systems
Oversee database upgrades, backups, monitoring, and tuning
Guide and mentor DBA team members
Develop and document operational standards and procedures
Collaborate across departments and with external stakeholders
Senior Database Administrator -
As a Sr. DBA, you'll support database design, installation, and administration. You'll play a key role in performance tuning, backup and recovery processes, and implementing operational standards. This role works closely with senior technical leadership to maintain database integrity and reliability.
What You'll Do:
Assist in the design and implementation of new database environments
Perform regular maintenance, upgrades, and backups
Collaborate with technical teams to resolve database issues
Contribute to documentation and best practices
Coordinate with technical leads and management for specialized support
Database Administrator II
As a DBA II, you'll focus on the daily operations of our databases, including maintenance, backup, restoration, and performance monitoring. You'll assist in environment design and contribute to the continuous improvement of DBA practices and procedures.
What You'll Do:
Monitor and maintain database systems and services
Assist with database environment design and storage planning
Implement and document DBA team procedures
Support backup and recovery efforts
Collaborate with peers and technical leads
Apply today to join a team where your expertise and innovation help keep the power grid secure and efficient.
To be successful in the role we're looking for:
Bachelor's degree in an Information Technology-related field, or equivalent job-related experience
Lead Database Administrator: Eight (8) years database management experience
Senior Database Administrator: Five (5) years database management experience
Database Administrator II: Three (3) years of database management experience
Excellent written and oral communications skills
Excellent analytical and problem solving abilities
Effective working knowledge/experience with Unix or Linux operations systems
Understanding of and compliance with SPP Policies and Procedures
Preferred Qualifications:
Expertise with Exadata Cloud at Customer (ExaCC) architecture, administration, installation, configuration, performance tuning, migration, patching, upgrade, etc.
Experience with Oracle
Experience with ExaCC and features like:
Smart Scan
Storage Indexing
Security Management
Automation Techniques
Backup and Recovery
Data Governance
Data Masking and Subsetting
Data Warehouse design and implementation
Work Environment:
This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.
Position Type, Location, and Hours:
This is a full-time, onsite hybrid position based in Little Rock, Arkansas. The standard workweek is Monday through Friday, from 8:00 a.m. to 5:00 p.m., with extended hours potentially required.
Travel Requirement:
This position requires minimal travel (approximately 10%).
SPP is an Affirmative Action and Equal Opportunity Employer of individuals with disabilities and protected veterans and is committed to excellence. If you need a reasonable accommodation for any part of the employment process, please contact us at ********** and let us know the nature of your request. We will only respond to messages left that involve a request for a reasonable accommodation in the application process. We will accommodate the needs of any qualified candidate who requests a reasonable accommodation under the Americans with Disabilities Act (ADA).
At SPP we believe in a culture of belonging. Learn more here: Culture of Belonging - Southwest Power Pool.
Full job descriptions will be made available to those selected for an interview.
Teradata Infrastructure DBA
Database administrator job in Oklahoma City, OK
Infrastructure DBA experience and Backup and Recovery experience Proven experience with Teradata database administration, performance tuning, and troubleshooting. Strong knowledge of SQL and experience with scripting languages such as Python or Bash. Familiarity with data warehousing concepts and processes.
Excellent problem-solving skills and attention to detail.
Ability to work independently and as part of a team in a fast-paced, high-pressure environment.
Experience with cloud platforms and services.
Teradata Platform Maintenance and Support
Teradata's latest DSA experience
Managing security policies and compliance
System Monitoring and Maintenance
Performance Tuning
Incident Management and Troubleshooting
Change and Release management
Base Salary Range: $100,000 - $130,000 per annum
TCS Employee Benefits Summary:
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
#LI-SV2
Enterprise Database Administrator - Tulsa, OK
Database administrator job in Tulsa, OK
WHO ARE WE: BlackHawk Industrial provides you the highest quality industrial products and equipment, offering manufacturing services while creating innovative engineered supply solutions. We truly believe in the importance of the local relationships with the customers we service. Our employees have fun every day exceeding the expectations of our customers, suppliers, and shareholders. We distinguish ourselves as the #1 choice of industrial manufacturers who are in need of Technical Service and Production Savings.
We are BIG ENOUGH TO SERVE, and SMALL ENOUGH TO CARE.
***This position is located onsite in Tulsa, OK***
SUMMARY: The Database Administrator (DBA) is responsible for the performance, integrity, and security of BlackHawk Industrial Inc.'s databases. This role involves managing database structures, monitoring system performance, planning for future growth, and ensuring data availability and security. The DBA will work closely with other IT team members and business units to support and optimize the company's database systems.
ESSENTIAL DUTIES AND RESPONSIBILITIES
**Database Management:**
Administer and support Epicor Prophet 21 solution, SQL databases, and data infrastructure onsite and across cloud-hosted environments.
Install, configure, and upgrade database server software and related products.
Perform database tuning and performance monitoring.
Plan growth and changes (capacity planning).
**Data Integrity and Security:**
Coordinate with the Infrastructure Manager to ensure data integrity and availability by implementing appropriate security measures.
Work with the Infrastructure Manager to develop, manage, and test backup and recovery plans.
Collaborate with the Infrastructure Manager to ensure that storage, archiving, backup, and recovery procedures are functioning correctly.
**Support and Maintenance:**
Perform full DBA functions including database provisioning and changes, patching, upgrades, backups, restores, replication, high availability, and disaster recovery.
Provide 24/7 support for critical production systems.
Perform regular maintenance, including applying patches and updates.
Troubleshoot and resolve database issues.
Coordinate with vendors for support and maintenance of database systems.
**Collaboration and Documentation:**
Collaborate with application teams on development, test, and production support for software implementations, migrations, and data initiatives.
Document database configurations, procedures, and policies.
Provide training and support to users on database-related topics.
**Performance Monitoring and Optimization:**
Monitor database performance and implement changes to optimize efficiency.
Analyze, design, and implement changes to improve database performance.
Develop and implement strategies for database tuning and performance enhancements.
Conduct performance troubleshooting and tuning to resolve issues and improve slow-running queries.
Develop automated maintenance plans, jobs, alerts, and monitoring of the data environment.
**Compliance and Standards:**
Utilize monitoring tools and develop standards to ensure databases meet uptime, reliability, security, and compliance objectives.
Ensure databases comply with industry standards and regulatory requirements.
Develop and enforce database standards, guidelines, and best practices.
Conduct regular audits to ensure compliance with company policies and procedures.
**Development and Reporting:**
Create schemas, indexes, stored procedures, functions, and optimize database code for maximum throughput.
Generate reports and data analysis to provide business insights to users and leadership.
QUALIFICATIONS
Proven analytical and problem-solving abilities.
Ability to effectively prioritize and execute tasks in a high-pressure environment.
Can conform to shifting priorities, demands and timeliness through analytical and problem-solving capabilities.
Keen attention to detail.
Technology Savvy.
Strong interpersonal and oral communication skills.
Adept at reading, writing, and interpreting technical documentation and procedure manuals.
Ability to present ideas and solutions in user-friendly language.
Unquestionable ethics and morals.
Highly self-motivated and directed.
Strong customer service orientation.
Skilled at working within a team-oriented, collaborative environment.
EDUCATION and/or EXPERIENCE
**Required:**
Bachelor's degree in Computer Science or a related technical field.
5+ years of DBA experience with enterprise-level solutions and SQL Server 2019 and higher.
Knowledge of T-SQL, SSIS, and SQL Server optimization and configuration best practices.
Proven experience with high availability, replication, clustering, AlwaysOn availability groups.
Expert troubleshooting, analysis, and performance tuning abilities.
Hands-on experience with software upgrades, patching, and system maintenance.
**Preferred:**
Epicor Prophet 21 knowledge.
Experience with Windows Server 2019 administration.
ERP or manufacturing systems DBA experience.
Familiarity with SQL Server 2019 containers and DevOps procedures.
CERTIFICATES, LICENSES, REGISTRATIONS
None required.
WORK ENVIRONMENT
Occasional evening and weekend work to meet deadlines.
Occasional overnight travel to meet with internal and external customers.
Sitting for extended periods of time.
Employee is regularly required to speak and understand English, stand, walk, sit, use hand to finger, handle or feel objects, tools or controls; reach with hands and arms.
Employee is required to use computer and other equipment.
Lifting and transporting of moderately heavy objects up to 50 pounds, such as computers and peripherals.
Specific vision abilities include close vision and the ability to clearly focus vision.
PPE REQUIRED:
Eye protection, ear protection, and as required by customer, steel-toed shoes and head protection.
BENEFITS:
Health Insurance BCBS of OK HDHP
HSA with Employer match (must meet criteria)
Dental and Vision Insurance
401K Plan and Company Match
FSA (Full FSA, Limited FSA, and Dependent FSA)
Company paid Long Term and Short-Term Disability
Company paid basic Life Insurance and AD&D/
Supplemental life and AD&D/Dependent life
Ancillary Critical Illness Insurance (Wellness Rider Included)
Ancillary Accident Insurance (Wellness Rider Included)
Ancillary Hospital Indemnity
Employee Assistance Program (EAP) - Includes concierge services and travel assistance.
Paid Time Off
Holiday Paid Time Off
Gym Reimbursement
Quarterly Wellness challenge with a chance to will money or prizes
Tuition Reimbursement - after 1 year of employment
*BlackHawk Industrial is an Equal Opportunity Employer
**As part of our BHID policy, we require all potential employees to undergo pre-employment background and drug screening. This is a standard procedure we follow to ensure a safe and productive work environment.
Auto-ApplyCuram DBA
Database administrator job in Little Rock, AR
ASK IT consulting is an equal opportunity employer, which is a global staffing, consulting and technology solutions company, offering industry-specific solutions to fortune 500 clients and worldwide corporations. We have openings for Curam DBA for one of our client in Little Rock, AR.
My name is Vikram Bhalla and I am Lead Recruiter with Ask IT Consulting. Ask IT Consulting Inc, backed by a $500 million Microtek group company, provides an industry leading blend of technology, business consulting, and outsourcing services. I am hiring for one of our direct client and I have gone through your resume from the job portal. I am sending you the job description mentioned below, if interested please revert with the updated copy of your resume in a word format.
Position: Curam Sr. DBA
Location : Little Rock AR 72201
Duration: 12 Months
Short Description : The Curam Database Administrator will be primarily responsible for the maintenance, enhancement and performance tuning support for the implementation of IBM's Curam Social Industry Platform . In addition, this person will be required to provide after hours support, 24 x 7 on a rotating basis.
The Senior Application DBA will manage be responsible for providing leadership in the implementation of the Curam data model and preparing the solution for operations.
• Day-to-day data model oversight.
• Developing a governance strategy to ensure consistent, sustainable, and scalable data model changes, with a focus on retaining the ability to easily update the Curam platform to future versions.
• Advising development and product teams on best approaches for required data model extensions and/or changes.
• Hands-on Oracle development and application in ways that are consistent with the Curam framework and Oracle best practices.
• Collaboration with Oracle administration team to maintain test, staging, production databases and the development of operations procedures for database management.
• Other duties as assigned.
Additional Information
Ask IT Consulting Inc.| 33 Peachtree St., Suite 100 |Holtsville, NY 11742
Website: **********************
Lead Database Administrator
Database administrator job in Little Rock, AR
About defi SOLUTIONS:
It's an exciting time to join defi!
defi SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest-volume captive auto lenders, banks, credit unions, and finance companies in North America. We have more than three decades of experience helping lenders reduce time-to-market, streamline operations, and customize lending processes with proven, scalable performance. Learn more at defisolutions.com and follow us on LinkedIn.
Position Purpose:
The Lead Database Administrator is responsible for managing all operational aspects of production and non-production database environments across multiple data centers supporting defi SOLUTIONS. This role oversees daily database performance, backups, tuning, patching, and overall maintenance of all database systems.
You will collaborate with operational and engineering teams to define requirements, architect solutions, and deliver reliable database services. Additionally, you'll work closely with Client Services, Relationship Management, and various development and technical teams to ensure the operational needs of both clients and internal users are consistently met.
This is a multifaceted role requiring strong communication, leadership, and technical expertise to maintain high availability, performance, and security across all database platforms. Participation with On-Call is a critical aspect of this role, ensuring 24/7 support and rapid response to production issues or outages.
Essential functions:
Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.
Setup, configure and manage SQL Server Always On Availability Groups on virtual machines.
Primary responsibilities include installation, configuration, security management, patching, upgrades, backups, restores, environment refreshes, performance tuning, routine maintenance, disaster recovery planning and alerting/monitoring.
Support ongoing database maintenance tasks, many of which must be completed within defined maintenance windows to ensure system availability and compliance.
Support both Azure and AWS SQL Enviornments
Interact with clients, analysts, and other team members to resolve issues.
Assist less experienced team members and assist in problem resolution as necessary.
Critical On-Call support to participate in incident and problem management processes and provide support as needed to ensure system reliability and timely issue resolution.
Stay Current on emerging technologies
Collaborate with other members of the Operations Team to design and implement solutions
Open and Escalate cases with Microsoft when required
**
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Required education and experience:
Bachelor's degree or equivalent work experience
10+ years' experience in an IT operations environment performing database administration.
3+ years of experience with Azure portal and all topics in Azure related to database maintenance including SQLMI and AzureSQL with failover groups as well as Azure CLI
3+ years of experience with AWS portal including CLI, S3, EC2, EBS and infrastructure knowledge
3+ years of experience with SQL Server Always On Availability Groups
PowerShell Scripting experience
Deep knowledge of SQL internal functionality including but not limited to
Query Processing and Optimization
Reading and Analyzing Execution plans, table statistics, data distribution and execution times
Indexing Mechanisms
Types, Maintenance and impact
Transaction Management
Isolation levels, Locking mechanisms, deadlocks, etc.
Storage Architecture
Data Pages, filegroups, row/page compression, etc.
Expert in large database design (logical, physical, conceptual) for OLTP and data warehouse environments using the Microsoft platform.
Backup and Recovery
Backup types, Recovery Models, PITR, Disaster Recovery Planning, etc.
Experience with maintaining high availability SQL environments and Disaster Recovery Strategies.
Security and Access Control
Authentication, Encryption, auditing, access requirements, etc.
Monitoring and Performance Tuning
Wait Statistics, Dynamic Management Views, Query Store, etc.
Experience with Datadog, Elastic or New Relic
Maintenance and Housekeeping
Database Consistency checks, statistics updates, index maintenance, log file management.
Experience using SQL Server Agent to develop and schedule administration jobs, alerts and groups.
Effective analytical, communication, interpersonal and problem-solving skills.
No management experience is required.
Preferred education and experience:
Knowledge in Snowflake Administration
Knowledge and experience working on Azure Cloud, Azure SQL and SQL Managed Instance is a plus
Knowledge in Azure resources such as Storage Accounts, Blob Storage, Keyvault, Azure Active Directory
Additional eligibility requirements:
An achiever, self-starter, and eager to learn
You'll have a proven track record of results as we'll expect you to act decisively, think big, and manage your time and your team's time to meet deadlines in a fast-paced, high-volume environment.
Most importantly, you'll want to contribute to a diverse, supportive, and talented team.
Travel required:
Travel is potential to be 10% of time
Affirmative Action/EEO statement:
defi SOLUTIONS is an Equal Opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status.
Senior Software Application Administrator
Database administrator job in Fort Smith, AR
Description & Requirements Maximus is seeking a Senior Application Software Administrator to design, deploy, and support middleware technologies-primarily JBoss EAP, Apache HTTP Server, and Apache Tomcat-in Windows environments. This role ensures strong performance, scalability, security, and reliability across our application ecosystem.
This is a remote position.
Essential Duties and Responsibilities:
- Perform work submitted by the project when reporting application issues such as performance and service availability.
- Application service management for all managed instances which includes monitoring request for compliance with corporate change policy standards.
- Manage the execution of all environmental changes such as deployments or key configuration changes performed outside the application.
- Manage the shutdown, recovery and testing of all impacted applications during Operating System patching cycles.
- Perform new environment startups and builds which comply with the application administration build standards.
- Manage application administrations and user provisioning as required or when these tasks cannot be delegated without introducing stability issues within the supported solution.
- Participate in after- hours support for assistance in production recovery or time sensitive changes which can only occur outside of standard business hours.
- Provide cross team mentoring and training to assist in propagating application knowledge to the junior team members and assist in strengthening their skills to avoid accidental application impacts to supported environments.
Job-Specific Essential Duties and Responsibilities:
- Administer and maintain middleware platforms across all environments.
- Perform patching, upgrades, and vulnerability remediation.
- Lead troubleshooting and root-cause analysis.
- Monitor and tune system performance; coordinate with vendors as needed.
- Document architectures, configurations, and procedures.
- Support new project planning and deployments.
- Participate in disaster recovery activities.
- Manage SSL certificates and security configurations.
Minimum Requirements
- Bachelor's degree in relevant field of study and 5+ years of relevant professional experience required, or equivalent combination of education and experience.
- Master's degree preferred.
- Weblogic, Tomcat or TC server and apache experience.
- In-depth knowledge of administration in a UNIX (Solaris) or Linux (RHEL) command-line environment.
- Proficient in writing and maintaining Unix shell scripts to automate system tasks.
- Experience with Puppet/Ansible or equivalent technologies.
- Optimize application performance by tuning application server components
- Thorough understanding of architectural elements required to support large installations and maintain high availability such as clustering, and load balancing w.r.t above listed applications.
- Able to work in fast paced environments and have understanding of programming environments.
- Proactive, can-do attitude whose actions work toward continuous process improvement.
- Strong analytical, troubleshooting, knowledge sharing, collaborative and mentoring skills.
- Superior troubleshooting and diagnostic abilities.
- Must be able to write effective technical documents and reports as a primary focus of daily duties.
- Excellent communication ability (verbal, written, and presentation) and a effective team player.
- Experience supporting all phases of the system development life cycle including development, testing, QA and production.
- Must exercise effective judgment and follow established procedures in support of production, 24x7, and other critical environments.
- Experience in installation, configuration and troubleshooting of Kofax Capture solutions a plus.
- Experience within supporting one or more of the following application instances desired: LifeRay, Crystal Report Server, Siebel CRM, OBIEE, OID, Oracle Forms and Reports, JIRA, IBM SmartCloud, Comodo TFA, InQuira, OnDemand, MicroStrategy, Hyperic, OEM, F5 and/or VMware Ops Center.
- Relevant industry certifications (Java, Unix/Linux, MCSE, Application Server, Database, Image Capture) preferred.
- Familiar with Microsoft IIS administration, configuration, and deployments for .NET applications preferred.
- Experience with database related utilities and tools such as Oracle SQL*Plus, Oracle Enterprise Manager, Microsoft SQL Server Enterprise Manager, and Microsoft Data Sources preferred.
- Knowledge of government sponsored health care programs and systems preferred.
Job-Specific Minimum Requirements:
- Hands-on JBoss and Apache server experience.
- Strong Windows application infrastructure background.
- 5-7 years of relevant experience.
- Bachelor's degree or equivalent experience.
- Strong communication skills.
Additional Requirements
- U.S. citizenship and current residency.
- Ability to obtain a 6C Public Trust clearance and pass a background check.
- Must not be in default on federal student loans.
- Must obtain and maintain a PIV-I card (travel covered by Maximus).
Preferred Skills and Qualifications:
- Patching and deploying Apache Tomcat and JBoss.
- Integrating COTS products and ETL solutions.
- Implementing SSO and two-factor authentication.
- Web and object-oriented programming knowledge (JavaScript, Java, HTML, XML, Perl, web services, IIS, ASP.NET).
- Scripting for automation (PowerShell, Perl).
- VMware or Hyper-V experience.
EEO Statement
Maximus is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, age, national origin, disability, veteran status, genetic information and other legally protected characteristics.
Pay Transparency
Maximus compensation is based on various factors including but not limited to job location, a candidate's education, training, experience, expected quality and quantity of work, required travel (if any), external market and internal value analysis including seniority and merit systems, as well as internal pay alignment. Annual salary is just one component of Maximus's total compensation package. Other rewards may include short- and long-term incentives as well as program-specific awards. Additionally, Maximus provides a variety of benefits to employees, including health insurance coverage, life and disability insurance, a retirement savings plan, paid holidays and paid time off. Compensation ranges may differ based on contract value but will be commensurate with job duties and relevant work experience. An applicant's salary history will not be used in determining compensation. Maximus will comply with regulatory minimum wage rates and exempt salary thresholds in all instances.
Accommodations
Maximus provides reasonable accommodations to individuals requiring assistance during any phase of the employment process due to a disability, medical condition, or physical or mental impairment. If you require assistance at any stage of the employment process-including accessing job postings, completing assessments, or participating in interviews,-please contact People Operations at applicantaccommodations@maximus.com.
Minimum Salary
$
100,000.00
Maximum Salary
$
110,000.00
Database Administrator
Database administrator job in Oklahoma City, OK
Job Posting Title Database Administrator Agency 090 OFFICE OF MANAGEMENT AND ENTERPRISE SERV Supervisory Organization IS-Data Job Posting End Date Refer to the date listed at the top of this posting, if available. Continuous if date is blank. Note: Applications will be accepted until 11:59 PM on the day prior to the posting end date above.
Estimated Appointment End Date (Continuous if Blank)
Full/Part-Time
Full time
Job Type
Regular
Compensation
Job Description
As a SQL Server Database Administrator with OMES you will enjoy:
* Generous leave including 15 days of vacation, 15 days of sick leave and 11 paid holidays annually.
* A comprehensive Benefit Package with a generous benefit allowance to offset the cost of insurance premiums for employees and their eligible dependents.
Job Details
* Full-time 40-hour work weeks.
* Support the Information Services Division.
* Salary is based on education and experience.
* Position is on-site in Oklahoma City, OK.
Position Summary
This position is assigned responsibilities involving the administration of SQL Server databases. This includes the design, development, maintenance, security administration, capacity planning, performance monitoring and tuning, upgrade, backup and recovery of SQL Server databases to ensure maximum availability, integrity, confidentiality and security of data.
Key Responsibilities
Database Installation, Configuration & Upgrades
* Install, configure, and maintain SQL Server instances across on-prem and cloud environments.
* Apply patches, cumulative updates, and perform version upgrades/migrations.
* Configure SQL Server components such as SSIS, SSRS, and SSAS when required.
Performance Monitoring & Optimization
* Monitor database performance using DMVs, Extended Events, Query Store, and other tools.
* Tune SQL queries, indexes, and execution plans to ensure optimal database performance.
* Troubleshoot blocking, deadlocks, and system bottlenecks.
Backup, Recovery & High Availability
* Develop and manage reliable database backup and recovery strategies.
* Perform restore scenarios including point-in-time recovery.
* Configure and support high-availability solutions such as Always On AGs, Failover Clustering, log shipping, and replication.
* Participate in disaster recovery planning and testing.
Security & Compliance
* Manage database security including logins, users, roles, and permissions.
* Implement encryption like TDE or its equivalent, auditing, and best-practice security measures.
* Ensure regulatory and internal compliance standards are met.
Database Maintenance & Operations
* Manage SQL Agent jobs, alerts, and automation processes.
* Perform ongoing maintenance: index management, statistics updates, DBCC integrity checks.
* Monitor database growth, storage utilization, and capacity planning.
* Execute schema changes, deployments, and environment refreshes.
Troubleshooting & Support
* Diagnose and resolve production incidents, errors, and performance degradation.
* Analyze logs, trace files, deadlock graphs, and memory dumps as needed.
* Provide on-call support for critical systems.
Automation & Scripting
* Create and maintain scripts using T-SQL and PowerShell to automate routine tasks.
* Build monitoring and alerting solutions to proactively identify issues.
Collaboration & Documentation
* Work closely with users, developers, system administrators, stakeholders and other teams.
* Document configurations, procedures, and runbooks for operational excellence.
* Assist in mentoring junior team members as needed.
Physical Demands and Work Environment
This position works in a comfortable office setting with a computer for a large percentage of the workday. The noise level in the work environment is usually mild. Occasional travel may be required.
Minimum Qualifications
Requirements include six years of experience in an information technology or data management field or an equivalent combination of education and experience, substituting 12 semester hours in computer science or management information systems course work for each year of the required experience.
Preference will be given to candidates who
* Demonstrated expertise with SQL Server 2008/2008 R2/2012/2014/2016/2017/2019/2022 features and performance tuning tools.
* Proven experience designing and supporting SQL server high-availability solutions such as Always On Availability Groups, Failover Clustering, replication, and log shipping.
* Advanced skills in T-SQL development, query tuning, and analyzing execution plans.
* Strong background with PowerShell scripting and automation of administrative tasks.
* Extensive experience managing large-scale databases and high-throughput systems.
* Proven experience building and managing Azure SQL, Azure Managed Instance, AWS RDS for SQL Server, Cloud SQL on Google Cloud Platform, or hybrid cloud architectures
* Experience with ETL tools (SSIS), reporting services (SSRS) and Azure data factory.
* Ability to lead or contribute to database modernization efforts, including cloud migration or consolidation projects.
* Experience in managing PostgreSQL, MySQL and SharePoint Databases.
* Excellent communication skills with the ability to collaborate across technical and business teams.
* Demonstrated ability to work effectively in cross-functional teams, including developers, system administrators, analysts, and business stakeholders.
* Relevant certifications such as: Microsoft Certified: Azure Database Administrator Associate, MCSE: Data Management and Analytics, MCSA: SQL Server
About OMES
The Office of Management and Enterprise Services provides excellent service, expert guidance and continuous improvement in support of our partners' goals. We are a highly qualified workforce committed to serve those who serve Oklahomans and make government run in the most efficient, innovative manner possible.
OMES is an Equal Opportunity Employer. Reasonable accommodation to individuals with disabilities may be provided upon request.
Equal Opportunity Employment
The State of Oklahoma is an equal opportunity employer and does not discriminate on the basis of genetic information, race, religion, color, sex, age, national origin, or disability.
Current active State of Oklahoma employees must apply for open positions internally through the Workday Jobs Hub.
If you are needing any extra assistance or have any questions relating to a job you have applied for, please click the link below and find the agency for which you applied for additional information:
Agency Contact
Auto-ApplyDatabase Administrator - Aerospace Medical Research (AMR11)
Database administrator job in Oklahoma City, OK
ProSidian is a Management and Operations Consulting Services Firm focusing on providing value to clients through tailored solutions based on industry leading practices. ProSidian services focus on the broad spectrum of Risk Management, Compliance, Business Process, IT Effectiveness, Energy & Sustainability, and Talent Management. We help forward thinking clients solve problems and improve operations.
Launched by former Big 4 Management Consultants; our multidisciplinary teams bring together the talents of nearly 190 professionals globally to complete a wide variety of engagements for Private Companies, Fortune 1,000 Enterprises, and Government Agencies of all sizes. Our Services are deployed across the enterprise, target drivers of economic profit (growth, margin and efficiency), and are aligned at the intersections of assets, processes, policies and people delivering value.
ProSidian clients represent a broad spectrum of industries to include but are not limited to Energy, Manufacturing, Chemical, Retail, Healthcare, Telecommunications, Hospitality, Pharmaceuticals, Banking & Financial Services, Transportation, Federal and State Government Agencies. Learn More About ProSidian Consulting at ******************
Job Description
ProSidian Seeks a Database Administrator - Aerospace Medical Research (AMR11) headquartered near CONUS - Oklahoma City, OK to support requirements for Aerospace and Defense Sector Clients.
This CONUS - Oklahoma City, OK | *** - Contract Contingent position currently best aligns with the Data Administrator Labor Category. Ideal candidates exhibit the ability to visualize, analyze, and convert data and experiences to meet performance challenges while confidently engaging in productive “Jugaad” and dialogue targeting mission success. ProSidian Team Members work to provide Gov't. - Federal (USA) Sector related Human Capital Solutions for Aerospace Medical Research and Technical Support Services on behalf of The Civil Aerospace Medical Institute (CAMI).
Database Administrator - Aerospace Medical Research (AMR11) Candidates shall work to support requirements for (Aerospace Medical Research Services) and shall work as part of a team in support of Aerospace Medical Research efforts. The candidate will complete tasks and activities contributing to deliverables and core mission functions in the Aerospace Medical Research space.
Must perform work as required by the Knowledge Management team, with typical tasks such as:
- Assist in administering on-site databases, including such duties as maintaining database integrity/operation and maintaining secure data accessibility.
- Act under minimal direction to assist in administering, improving, and expanding on-site databases to maintain and increase database and system reliability, security, and accessibility.
- Conduct security assessments and ensure that data security is maintained.
- Work with individual users as needed to install, troubleshoot, and return user software to operational or compliant status.
- Maintain server logs, interact with and respond to FAA security assessment -personnel during security assessments and during follow-up actions.
- Assist in maintaining security of research computer systems, including selecting, installing, and maintaining security software.
- Provide assistance as needed in designing scripts in Python, R, BASH, PBS, or other computing languages and software according to experience.
#TechnicalCrossCuttingJobs #AerospaceMedicalResearch #Jugaad #AerospaceMedical
Qualifications
- B.S. degree or higher in Database Administration, Computer Science with one year of experience administering secure, onsite databases in accordance with applicable cybersecurity regulations or procedures, OR high school diploma plus five years of experience administering secure, onsite databases in accordance with applicable cybersecurity regulations or procedures.
- One year experience in assessing and maintaining database security and authorized user accessibility.
- One year experience in implementing database security requirements.
- One year experience working productively in a team environment, meeting deadlines, and responding to requests according to defined response timelines and resolving computer user service requests
- One year of experience managing SQL databases and using Microsoft SQL Server software.
- Two years of experience with Microsoft Windows Server OS. At least one year experience testing, updating, troubleshooting, and maintaining database-related software.
- Problem solving ability allowing individual to examine, troubleshoot, and solve database issues with minimal or no assistance.
- Three years of work experiences as a database administrator.
- At least 2 years' experience designing and running computational scripts using Python, R or similar languages.
- Must have at least 3 years of experience with teamwork and interpersonal communication, including interaction with team members, users/customers with varying levels of expertise, and management personnel.
U.S. Citizenship Required - You must be a United States Citizen
Excellent oral and written communication skills (This employer participates in the e-Verify program)
Proficient with Microsoft Office Products (Microsoft Word, Excel, PowerPoint, Publisher, & Adobe)
All ProSidian staff must be determined eligible for a “Facility Access Authorization” (also referred to as an “Employment Authorization”) by the USG's designated Security Office.
Other Requirements and Conditions of Employment Apply
May be required to complete a Financial Disclosure Statement
Must be able to submit to and qualify for varying levels of background investigative requirements, up to a Top Secret or DOE "Q" clearance.
#TechnicalCrossCuttingJobs #AerospaceMedicalResearch #Jugaad #AerospaceMedical
Additional Information
As a condition of employment, all employees are required to fulfill all requirements of the roles for which they are employed; establish, manage, pursue, and fulfill annual goals and objectives with at least three (3) Goals for each of the firms Eight Prosidian Global Competencies [1 - Personal Effectiveness | 2 - Continuous Learning | 3 - Leadership | 4 - Client Service | 5 - Business Management | 6 - Business Development | 7 - Technical Expertise | 8 - Innovation & Knowledge Sharing (Thought Leadership)]; and to support all business development and other efforts on behalf of ProSidian Consulting.
CORE COMPETENCIES
Teamwork - ability to foster teamwork collaboratively as a participant, and effectively as a team leader
Leadership - ability to guide and lead colleagues on projects and initiatives
Business Acumen - understanding and insight into how organizations perform, including business processes, data, systems, and people
Communication - ability to effectively communicate to stakeholders of all levels orally and in writing
Motivation - persistent in pursuit of quality and optimal client and company solutions
Agility - ability to quickly understand and transition between different projects, concepts, initiatives, or work streams
Judgment - exercises prudence and insight in decision-making process while mindful of other stakeholders and long-term ramifications
Organization - ability to manage projects and activity, and prioritize tasks
----------- ------------ ------------
OTHER REQUIREMENTS
Business Tools - understanding and proficiency with business tools and technology, including Microsoft Office. The ideal candidate is advanced with Excel, Access, Outlook, PowerPoint and Word, and proficient with Adobe Acrobat, data analytic tools, and Visio with the ability to quickly learn other tools as necessary.
Commitment - to work with smart, interesting people with diverse backgrounds to solve the biggest challenges across private, public and social sectors
Curiosity - the ideal candidate exhibits an inquisitive nature and the ability to question the status quo among a community of people they enjoy and teams that work well together
Humility - exhibits grace in success and failure while doing meaningful work where skills have impact and make a difference
Willingness - to constantly learn, share, and grow and to view the world as their classroom
------------ ------------ ------------
BENEFITS AND HIGHLIGHTS
ProSidian Employee Benefits and Highlights: Your good health and well-being are important to ProSidian Consulting. At ProSidian, we invest in our employees to help them stay healthy and achieve work-life balance. That's why we are also pleased to offer the Employee Benefits Program, designed to promote your health and personal welfare. Our growing list of benefits currently include the following for Full Time Employees:
Competitive Compensation: Pay range begins in the competitive ranges with Group Health Benefits, Pre-tax Employee Benefits, and Performance Incentives. For medical and dental benefits, the Company contributes a fixed dollar amount each month towards the plan you elect. Contributions are deducted on a Pre-tax basis.
Group Medical Health Insurance Benefits: ProSidian partners with BC/BS, to offer a range of medical plans, including high-deductible health plans or PPOs. ||| Group Dental Health Insurance Benefits: ProSidian dental carriers - Delta, Aetna, Guardian, and MetLife.
Group Vision Health Insurance Benefits: ProSidian offers high/low vision plans through 2 carriers: Aetna and VSP.
401(k) Retirement Savings Plan: 401(k) Retirement Savings Plans help you save for your retirement for eligible employees. A range of investment options are available with a personal financial planner to assist you. The Plan is a pre-tax Safe Harbor 401(k) Retirement Savings Plan with a company match.
Vacation and Paid Time-Off (PTO) Benefits: Eligible employees use PTO for vacation, a doctor's appointment, or any number of events in your life. Currently these benefits include Vacation/Sick days - 2 weeks/3 days | Holidays - 10 ProSidian and Government Days are given.
Pre-Tax Payment Programs: Pre-Tax Payment Programs currently exist in the form of a Premium Only Plan (POP). These Plans offer a full Flexible Spending Account (FSA) Plan and a tax benefit for eligible employees.
Purchasing Discounts & Savings Plans: We want you to achieve financial success. We offer a Purchasing Discounts & Savings Plan through The Corporate Perks Benefit Program. This provides special discounts for eligible employees on products and services you buy on a daily basis.
Security Clearance: Due to the nature of our consulting engagements there are Security Clearance requirements for Engagement Teams handling sensitive Engagements in the Federal Marketplace. A Security Clearance is a valued asset in your professional portfolio and adds to your credentials.
ProSidian Employee & Contractor Referral Bonus Program: ProSidian Consulting will pay up to 5k for all referrals employed for 90 days for candidates submitted through our Referral Program.
Performance Incentives: Due to the nature of our consulting engagements there are performance incentives associated with each new client that each employee works to pursue and support.
Flexible Spending Account: FSAs help you pay for eligible out-of-pocket health care and dependent day care expenses on a pre-tax basis. You determine your projected expenses for the Plan Year and then elect to set aside a portion of each paycheck into your FSA.
Supplemental Life/Accidental Death and Dismemberment Insurance: If you want extra protection for yourself and your eligible dependents, you have the option to elect supplemental life insurance. D&D covers death or dismemberment from an accident only.
Short- and Long-Term Disability Insurance: Disability insurance plans are designed to provide income protection while you recover from a disability.
---------- ------------ ------------
ADDITIONAL INFORMATION - See Below Instructions On The Best Way To Apply
ProSidian Consulting is an equal opportunity employer and considers qualified applicants for employment without regard to race, color, creed, religion, national origin, sex, sexual orientation, gender identity and expression, age, disability, or Vietnam era, or other eligible veteran status, or any other protected factor. All your information will be kept confidential according to EEO guidelines.
ProSidian Consulting has made a pledge to the Hiring Our Heroes Program of the U.S. Chamber of Commerce Foundation and the “I Hire Military” Initiative of The North Carolina Military Business Center (NCMBC) for the State of North Carolina. All applicants are encouraged to apply regardless of Veteran Status.
Furthermore, we believe in "HONOR ABOVE ALL" - be successful while doing things the right way. The pride comes out of the challenge; the reward is excellence in the work.
FOR EASY APPLICATION USE OUR CAREER SITE LOCATED ON ************************* OR SEND YOUR RESUME'S, BIOS, AND SALARY EXPECTATION / RATES TO ***********************.
ONLY CANDIDATES WITH REQUIRED CRITERIA ARE CONSIDERED.
Be sure to place the job reference code in the subject line of your email. Be sure to include your name, address, telephone number, total compensation package, employment history, and educational credentials.
Easy ApplyZ/Os Db2 Dba
Database administrator job in Little Rock, AR
360 IT Professionals is a Software Development Company based in Fremont, California that offers complete technology services in Mobile development, Web development, Cloud computing and IT staffing. Merging Information Technology skills in all its services and operations, the company caters to its globally positioned clients by providing dynamic feasible IT solutions. 360 IT Professionals work along with its clients to deliver high-performance results, based exclusively on the one of a kind requirement.
Our services are vast and we produce software and web products. We specialize in Mobile development, i.e. iPhone and Android apps. We use Objective-C and Swift programming languages to create native applications for iPhone, whereas we use Android Code to develop native applications for Android devices. To create applications that work on cross-platforms, we use a number of frameworks such as Titanium, PhoneGap and Jquery mobile.
Furthermore, we build web products and offer services such as web designing, layouts, responsive designing, graphic designing, web application development using frameworks based on model view controller architecture and content management system. Our services also extend to the domain of Cloud Computing, where we provide Salesforce CRM to effectively manage one's business and ease out all the operations by giving an easy platform. Apart from this, we also provide IT Staffing services that can help your organization to a great extent as you can hire highly skilled personnel's through us.
We make sure that we deliver performance-driven products that are optimally developed as per your organization's needs. Take a shot at us for your IT requirements and experience a radical change.
Job Description
Description: The Z/OS DB2 DBA will be primarily responsible for the maintenance, enhancement and performance tuning of z/OS DB2 databases as well as VSAM files, JCL, and TSO. The DBA will also work as part of a team to provide DB2 DBMS subsystem management.
In addition, this person will be required to provide after hours support, 24 x 7 on a rotating basis.
While z/OS support will be the primary responsibility of the Database Administrator, providing maintenance, enhancement and operational support to additional DBMSs like DB2 UDB and SQL Server will be required.
Qualifications:
Bachelor's Degree in Computer Science or related technical field
In-depth z/OS DB2 Database Administration (V9) experience (3+ years).
Solid experience with VSAM files, JCL, and TSO.
DBA certifications a plus.
Database Administration experience with DB2 UDB on LUW, SQL Server , CA tools and REX will be a plus.
Responsibilities:
•Database administration, implementation, and maintenance tasks including but not limited to:
-Enforcing database naming/creation/deletion standards in the Test and Production environments
-Establish, oversee, and optimize all database maintenance (i.e. update statistics, etc) and backup processes
-Enforce and implement appropriate security measures
•Troubleshoot application database issues
•Ensure the 24/7 availability and performance of the databases that support our systems, including "on-call" responsibilities
•Optimize the hardware/system resources allocated to the databases for high availability & minimum downtime
•Provide assistance to developers in DBMS performance tuning, best practices and problem resolution.
•Resolve database performance issues, database capacity issues, and other data issues
•Manage backup and recovery of databases
•Prepare, maintain and execute disaster recovery plans
•Monitor databases for errors and perform problem determination when necessary
Additional Information
Thanks and Regards,
Ankur Bhatia
DB2 DBA
Database administrator job in Little Rock, AR
IT professionals are always expected to do more with less. Amzur's Global Staff Augmentation Services can help fill your short- or long-term skill gaps so you can successfully meet even the most aggressive project goals. Our deep bench of skilled, certified experts have a successful track record across multiple industries and client technologies. From Staff Augmentation, SOW's to MSP/VMS, Amzur's talent acquisition team provides meticulous process oriented services - unmatched by none.
Job Description
Duration: 4-6 months CTH
Design and create and alter Databases, Tablespaces, Tables, Indexes, Views to meet the business requirements.
Setup appropriate security to allow access to the databases and tables.
Ability to establish both database backup and Disaster Recovery procedures - mirroring and clustering.
Ability to identify performance issues and recommend solutions - primarily index design, but could include SQL changes.
Ability to setup and run the utilities to prevent performance or space problems - run the reorg and statistics utilities.
Assist the System Administrators, Application Developers and End Users with database related problems.
Assist Operations with after hours on-call support.
Self starter.
Works well with others - we need team players.
Qualifications
The AIX DBA will need experience with: DB2 version 10 and 10.5 and Experience with the DPF product.
Additional Information
All your information will be kept confidential according to EEO guidelines.
SQL Database Administrator
Database administrator job in Little Rock, AR
Arete Technologies, Inc. offers set of innovative Consulting and Outsourcing services, bridging the gap between requirements and outputs of various dexterous and facile companies worldwide. The thrust of providing global deliverables with focus on providing paramount and unsurpassed services combined with cost saving solutions to the clients
We understand the business requirements in the present day corporate scenario and aspire to provide world-class services enabling the organization to burgeon and flourish while keeping the work-life balance intact. The Global delivery mechanism followed at Arete Technologies, Inc. saddles proficient schemas and unconventional channels to provide one-stop solutions for all your workforce needs.
our Team is an exquisite amalgamation of vast experiences of over 30 years in IT Consulting and Staffing industry. Connoisseurs in the field of staff augmentation for IT, we operate on 24 by 7 model with an aim of providing affordable and adept professionals with an assurance of satisfaction for both Consultants and Clients.
We are pre-eminent service providers in the field of staff augmentation, IT Consultancy, Software development, Web Development providing unexcelled services and focusing on both the employers and employees.
Job Description
Short Description:
The Senior Database Administrator will work under the supervision of current ADE - Network & Server Administration staff to build and augment internal capacity; migrate and support the databases for ADE Education Information Systems.
Description: The Senior Database Administrator will be a member of the Dev-Ops Team and will be responsible for directly supporting the daily administration of the agency's Microsoft SQL Server databases. Responsibilities include capacity planning work (including migration) and monitoring database growth and design, maintaining and ensuring High Availability solutions including replication, clustering, performance tuning etc. The position will be a strict staff augmentation position for a period of 6 - 8 months.
Duties and Responsibilities
• Perform Microsoft SQL database administration including software installations/configurations for SQL Server 2012/2014 to 2016/2017 including SSDT, SSIS, SSRS, SSAS and peripheral features/products such as log shipping, mirroring, and maintenance packs (bb cc, backups, re-indexing).
• Troubleshoot complex systems to identify bottlenecks (SQL, IO, hardware, query related, etc.) and resolve database related issues.
• Responsibilities include capacity planning work (on Production, UAT, DEV and DR environments); platform migration and monitoring database growth and design, maintaining and ensuring High Availability solutions including replication, clustering, performance tuning etc.
• Duties include developing and enforcing database standards and best practices including performance, security, monitoring policies and procedures along with researching improvements to enhance overall system performance.
• Provide hands-on training, mentoring and support to current ADE - Network & Server Administration staff with Microsoft SQL Server databases.
Qualifications
A successful candidate may have experience with:
Qualifications
***Must have Education Client Experience***
***State Experience***
Additional Information
Best Regards,
Amrit Lal
Lead Database Administrator
Database administrator job in Bay, AR
It's an exciting time to join defi! defi SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest-volume captive auto lenders, banks, credit unions, and finance companies in North America. We have more than three decades of experience helping lenders reduce time-to-market, streamline operations, and customize lending processes with proven, scalable performance. Learn more at defisolutions.com and follow us on LinkedIn.
Position Purpose:
The Lead Database Administrator is responsible for managing all operational aspects of production and non-production database environments across multiple data centers supporting defi SOLUTIONS. This role oversees daily database performance, backups, tuning, patching, and overall maintenance of all database systems.
You will collaborate with operational and engineering teams to define requirements, architect solutions, and deliver reliable database services. Additionally, you'll work closely with Client Services, Relationship Management, and various development and technical teams to ensure the operational needs of both clients and internal users are consistently met.
This is a multifaceted role requiring strong communication, leadership, and technical expertise to maintain high availability, performance, and security across all database platforms. Participation with On-Call is a critical aspect of this role, ensuring 24/7 support and rapid response to production issues or outages.
Essential functions:
Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.
* Setup, configure and manage SQL Server Always On Availability Groups on virtual machines.
* Primary responsibilities include installation, configuration, security management, patching, upgrades, backups, restores, environment refreshes, performance tuning, routine maintenance, disaster recovery planning and alerting/monitoring.
* Support ongoing database maintenance tasks, many of which must be completed within defined maintenance windows to ensure system availability and compliance.
* Support both Azure and AWS SQL Enviornments
* Interact with clients, analysts, and other team members to resolve issues.
* Assist less experienced team members and assist in problem resolution as necessary.
* Critical On-Call support to participate in incident and problem management processes and provide support as needed to ensure system reliability and timely issue resolution.
* Stay Current on emerging technologies
* Collaborate with other members of the Operations Team to design and implement solutions
* Open and Escalate cases with Microsoft when required
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Required education and experience:
* Bachelor's degree or equivalent work experience
* 10+ years' experience in an IT operations environment performing database administration.
* 3+ years of experience with Azure portal and all topics in Azure related to database maintenance including SQLMI and AzureSQL with failover groups as well as Azure CLI
* 3+ years of experience with AWS portal including CLI, S3, EC2, EBS and infrastructure knowledge
* 3+ years of experience with SQL Server Always On Availability Groups
* PowerShell Scripting experience
* Deep knowledge of SQL internal functionality including but not limited to
* Query Processing and Optimization
* Reading and Analyzing Execution plans, table statistics, data distribution and execution times
* Indexing Mechanisms
* Types, Maintenance and impact
* Transaction Management
* Isolation levels, Locking mechanisms, deadlocks, etc.
* Storage Architecture
* Data Pages, filegroups, row/page compression, etc.
* Expert in large database design (logical, physical, conceptual) for OLTP and data warehouse environments using the Microsoft platform.
* Backup and Recovery
* Backup types, Recovery Models, PITR, Disaster Recovery Planning, etc.
* Experience with maintaining high availability SQL environments and Disaster Recovery Strategies.
* Security and Access Control
* Authentication, Encryption, auditing, access requirements, etc.
* Monitoring and Performance Tuning
* Wait Statistics, Dynamic Management Views, Query Store, etc.
* Experience with Datadog, Elastic or New Relic
* Maintenance and Housekeeping
* Database Consistency checks, statistics updates, index maintenance, log file management.
* Experience using SQL Server Agent to develop and schedule administration jobs, alerts and groups.
* Effective analytical, communication, interpersonal and problem-solving skills.
* No management experience is required.
Preferred education and experience:
* Knowledge in Snowflake Administration
* Knowledge and experience working on Azure Cloud, Azure SQL and SQL Managed Instance is a plus
* Knowledge in Azure resources such as Storage Accounts, Blob Storage, Keyvault, Azure Active Directory
Additional eligibility requirements:
* An achiever, self-starter, and eager to learn
* You'll have a proven track record of results as we'll expect you to act decisively, think big, and manage your time and your team's time to meet deadlines in a fast-paced, high-volume environment.
* Most importantly, you'll want to contribute to a diverse, supportive, and talented team.
Travel required:
* Travel is potential to be 10% of time
Affirmative Action/EEO statement:
defi SOLUTIONS is an Equal Opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status.
Database Developer
Database administrator job in Oklahoma City, OK
We are seeking a skilled Database Developer to join our team. The ideal candidate will be responsible for designing and implementing database objects such as tables, views, and stored procedures, as well as developing SSIS packages for data import processes. Experience working with EBCDIC file formats is a strong plus.
Key Responsibilities
Design, create, and maintain database tables, views, and indexes in Microsoft SQL Server.
Develop and optimize SSIS packages for importing and transforming data from various sources.
Ensure data integrity and consistency during ETL processes.
Collaborate with business analysts and application developers to understand data requirements.
Troubleshoot and resolve issues related to data imports and database performance.
Document database structures, processes, and workflows.
Work with multiple data sources, including EBCDIC file sources, for data import.
Qualifications
Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience).
2+ years of experience in SQL Server development.
Strong proficiency in T-SQL for creating tables, views, and stored procedures.
Hands-on experience with SSIS for ETL processes.
Familiarity with EBCDIC file formats and mainframe data sources is a plus.
Knowledge of data modeling and database design principles.
Excellent problem-solving and communication skills.
Preferred Skills
Experience with performance tuning and query optimization.
Understanding of data warehousing concepts.
Self-driven with the ability to work independently as well as in a team environment.
Strong analytical and problem-solving abilities.
Excellent communication skills for cross-team collaboration.
Ability to prioritize tasks and manage multiple projects effectively.
Attention to detail and commitment to data accuracy.
Adaptability in a fast-paced environment.
Team-oriented mindset with a proactive approach.
* Must reside within the market area to be considered.
*Position requires a minimum of 3 years of relevant US based experience.
#LI-DNI
Teradata Operations DBA
Database administrator job in Box, OK
The Teradata Operations DBA is a member of the Information Stores team that manages the physical data stores for the enterprise. This includes working with data modeling and development teams to create new databases, replicate data across environments, monitor and manage databases, perform SQL tuning and analysis, provide capacity planning, grant data level access privileges and provide consultation to application development teams on design issues. The Teradata DBA has knowledge about database platforms and independently leads the implementation for high priority and complex enterprise databases. Coordinate and lead the definition of database backup/recovery and security strategies. Responsible for mentoring and training other database administrators, managing task assignments for junior database administrators, reviewing work and providing input to performance reviews.
MAJOR TASKS, RESPONSIBILITIES AND KEY ACCOUNTABILITIES
Review physical database structures using complex technical skills based on physical design for development, test, and production environments.
Responsible for complex database performance tuning, security, backup/recovery strategy, and implementing monitoring procedures to maximize system availability.
Active in security design, including designing and implementing roles, profiles and accounts.
Managing and tuning Teradata Workload Management - designing and creating workload groups, priorities, throttles, etc.
Mentoring and training other associate database administrators, managing task assignments, reviewing work and providing input to Management.
Implementing monitoring procedures to maximize system availability and performance, to meet defined service targets.
Coordination with system engineers to configure servers for DBMS product installation and complex database creation.
Configure and maintain DBMS product software on complex database and application servers.
PREFERRED QUALIFICATIONS
Position Requirements:
High degree of skill with database commands and Teradata utilities such as Manager, Administrator, SQL Assistant, TSET,TPT, Visual Explain, Arcmain, TASM, etc.
Strong verbal and written communication skills.
Ability to present to audiences to include various levels of management.
Proven ability to lead projects across multi-departmental teams.
Advanced knowledge of database administration tasks such as Database Console utilities, security, work-load management (TASM), TDatamover, BAR including NetBackup and TaraGui.
Previous experience with issues around database, client tool, and hardware upgrades.
Setup ViewPoint portlets for monitoring space and system health.
Ability to write, debug and tune SQL, macros, procedures, implementation of multi-value compression, etc.
Experience with database monitoring and tuning tools such as Teradata Manager and PDCR.
Experience with the SUSE 10 or higher Linux operating system and command set as well as competence with shell scripting
Experience:
Five to seven years as Teradata database administrator.
Experience leading projects/teams in a large, 24x7 environment.
Experience managing a large enterprise user base in a multi-terabyte, multi-application Teradata database system.
Ability to lead the development and management of database design standards.
In-depth experience in security administration using roles and profiles.
Qualifications
Please, send your resume with rate.
Additional Information
Apply today!
Lead Database Administrator
Database administrator job in Oklahoma City, OK
About defi SOLUTIONS:
It's an exciting time to join defi!
defi SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest-volume captive auto lenders, banks, credit unions, and finance companies in North America. We have more than three decades of experience helping lenders reduce time-to-market, streamline operations, and customize lending processes with proven, scalable performance. Learn more at defisolutions.com and follow us on LinkedIn.
Position Purpose:
The Lead Database Administrator is responsible for managing all operational aspects of production and non-production database environments across multiple data centers supporting defi SOLUTIONS. This role oversees daily database performance, backups, tuning, patching, and overall maintenance of all database systems.
You will collaborate with operational and engineering teams to define requirements, architect solutions, and deliver reliable database services. Additionally, you'll work closely with Client Services, Relationship Management, and various development and technical teams to ensure the operational needs of both clients and internal users are consistently met.
This is a multifaceted role requiring strong communication, leadership, and technical expertise to maintain high availability, performance, and security across all database platforms. Participation with On-Call is a critical aspect of this role, ensuring 24/7 support and rapid response to production issues or outages.
Essential functions:
Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.
Setup, configure and manage SQL Server Always On Availability Groups on virtual machines.
Primary responsibilities include installation, configuration, security management, patching, upgrades, backups, restores, environment refreshes, performance tuning, routine maintenance, disaster recovery planning and alerting/monitoring.
Support ongoing database maintenance tasks, many of which must be completed within defined maintenance windows to ensure system availability and compliance.
Support both Azure and AWS SQL Enviornments
Interact with clients, analysts, and other team members to resolve issues.
Assist less experienced team members and assist in problem resolution as necessary.
Critical On-Call support to participate in incident and problem management processes and provide support as needed to ensure system reliability and timely issue resolution.
Stay Current on emerging technologies
Collaborate with other members of the Operations Team to design and implement solutions
Open and Escalate cases with Microsoft when required
**
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Required education and experience:
Bachelor's degree or equivalent work experience
10+ years' experience in an IT operations environment performing database administration.
3+ years of experience with Azure portal and all topics in Azure related to database maintenance including SQLMI and AzureSQL with failover groups as well as Azure CLI
3+ years of experience with AWS portal including CLI, S3, EC2, EBS and infrastructure knowledge
3+ years of experience with SQL Server Always On Availability Groups
PowerShell Scripting experience
Deep knowledge of SQL internal functionality including but not limited to
Query Processing and Optimization
Reading and Analyzing Execution plans, table statistics, data distribution and execution times
Indexing Mechanisms
Types, Maintenance and impact
Transaction Management
Isolation levels, Locking mechanisms, deadlocks, etc.
Storage Architecture
Data Pages, filegroups, row/page compression, etc.
Expert in large database design (logical, physical, conceptual) for OLTP and data warehouse environments using the Microsoft platform.
Backup and Recovery
Backup types, Recovery Models, PITR, Disaster Recovery Planning, etc.
Experience with maintaining high availability SQL environments and Disaster Recovery Strategies.
Security and Access Control
Authentication, Encryption, auditing, access requirements, etc.
Monitoring and Performance Tuning
Wait Statistics, Dynamic Management Views, Query Store, etc.
Experience with Datadog, Elastic or New Relic
Maintenance and Housekeeping
Database Consistency checks, statistics updates, index maintenance, log file management.
Experience using SQL Server Agent to develop and schedule administration jobs, alerts and groups.
Effective analytical, communication, interpersonal and problem-solving skills.
No management experience is required.
Preferred education and experience:
Knowledge in Snowflake Administration
Knowledge and experience working on Azure Cloud, Azure SQL and SQL Managed Instance is a plus
Knowledge in Azure resources such as Storage Accounts, Blob Storage, Keyvault, Azure Active Directory
Additional eligibility requirements:
An achiever, self-starter, and eager to learn
You'll have a proven track record of results as we'll expect you to act decisively, think big, and manage your time and your team's time to meet deadlines in a fast-paced, high-volume environment.
Most importantly, you'll want to contribute to a diverse, supportive, and talented team.
Travel required:
Travel is potential to be 10% of time
Affirmative Action/EEO statement:
defi SOLUTIONS is an Equal Opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status.
SQL Database Administrator
Database administrator job in Little Rock, AR
Arete Technologies, Inc. offers set of innovative Consulting and Outsourcing services, bridging the gap between requirements and outputs of various dexterous and facile companies worldwide. The thrust of providing global deliverables with focus on providing paramount and unsurpassed services combined with cost saving solutions to the clients
We understand the business requirements in the present day corporate scenario and aspire to provide world-class services enabling the organization to burgeon and flourish while keeping the work-life balance intact. The Global delivery mechanism followed at Arete Technologies, Inc. saddles proficient schemas and unconventional channels to provide one-stop solutions for all your workforce needs.
our Team is an exquisite amalgamation of vast experiences of over 30 years in IT Consulting and Staffing industry. Connoisseurs in the field of staff augmentation for IT, we operate on 24 by 7 model with an aim of providing affordable and adept professionals with an assurance of satisfaction for both Consultants and Clients.
We are pre-eminent service providers in the field of staff augmentation, IT Consultancy, Software development, Web Development providing unexcelled services and focusing on both the employers and employees.
Job Description
Short Description:
The Senior Database Administrator will work under the supervision of current ADE - Network & Server Administration staff to build and augment internal capacity; migrate and support the databases for ADE Education Information Systems.
Description: The Senior Database Administrator will be a member of the Dev-Ops Team and will be responsible for directly supporting the daily administration of the agency's Microsoft SQL Server databases. Responsibilities include capacity planning work (including migration) and monitoring database growth and design, maintaining and ensuring High Availability solutions including replication, clustering, performance tuning etc. The position will be a strict staff augmentation position for a period of 6 - 8 months.
Duties and Responsibilities
Perform Microsoft SQL database administration including software installations/configurations for SQL Server 2012/2014 to 2016/2017 including SSDT, SSIS, SSRS, SSAS and peripheral features/products such as log shipping, mirroring, and maintenance packs (bb cc, backups, reindexing).
Troubleshoot complex systems to identify bottlenecks (SQL, IO, hardware, query related, etc.) and resolve database related issues.
Responsibilities include capacity planning work (on Production, UAT, DEV and DR environments); platform migration and monitoring database growth and design, maintaining and ensuring High Availability solutions including replication, clustering, performance tuning etc.
Duties include developing and enforcing database standards and best practices including performance, security, monitoring policies and procedures along with researching improvements to enhance overall system performance.
Provide hands-on training, mentoring and support to current ADE - Network & Server Administration staff with Microsoft SQL Server databases.
Qualifications
A successful candidate may have experience with:
8+ years of experience developing, maintaining and administering Microsoft SQL Server databases.
Bachelor's degree in Computer Science/Information Science or equivalent work experience.
Involved in prior enterprise-level databases migrations and deployments.
Experience required in configuring SQL Server replication across data center.
Hands-on experience with MS SQL Server 2017/2016; 2014; 2012 versions.
Hands-on experience with SQL monitoring tools - Red Gate; SQL Sentry; etc.
Special Requirements
Experience with Business Intelligence and Data Warehouse products preferred. Development experience with complicated DTS/SSIS Package coding and maintenance a plus. Experience with Data Modeling Tools as well as creating and maintaining data models preferred.
Qualifications
***Must have Education Client Experience***
Additional Information
Best Regards,
Amrit Lal
Lead Database Administrator
Database administrator job in Box, OK
It's an exciting time to join defi! defi SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest-volume captive auto lenders, banks, credit unions, and finance companies in North America. We have more than three decades of experience helping lenders reduce time-to-market, streamline operations, and customize lending processes with proven, scalable performance. Learn more at defisolutions.com and follow us on LinkedIn.
Position Purpose:
The Lead Database Administrator is responsible for managing all operational aspects of production and non-production database environments across multiple data centers supporting defi SOLUTIONS. This role oversees daily database performance, backups, tuning, patching, and overall maintenance of all database systems.
You will collaborate with operational and engineering teams to define requirements, architect solutions, and deliver reliable database services. Additionally, you'll work closely with Client Services, Relationship Management, and various development and technical teams to ensure the operational needs of both clients and internal users are consistently met.
This is a multifaceted role requiring strong communication, leadership, and technical expertise to maintain high availability, performance, and security across all database platforms. Participation with On-Call is a critical aspect of this role, ensuring 24/7 support and rapid response to production issues or outages.
Essential functions:
Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.
* Setup, configure and manage SQL Server Always On Availability Groups on virtual machines.
* Primary responsibilities include installation, configuration, security management, patching, upgrades, backups, restores, environment refreshes, performance tuning, routine maintenance, disaster recovery planning and alerting/monitoring.
* Support ongoing database maintenance tasks, many of which must be completed within defined maintenance windows to ensure system availability and compliance.
* Support both Azure and AWS SQL Enviornments
* Interact with clients, analysts, and other team members to resolve issues.
* Assist less experienced team members and assist in problem resolution as necessary.
* Critical On-Call support to participate in incident and problem management processes and provide support as needed to ensure system reliability and timely issue resolution.
* Stay Current on emerging technologies
* Collaborate with other members of the Operations Team to design and implement solutions
* Open and Escalate cases with Microsoft when required
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Required education and experience:
* Bachelor's degree or equivalent work experience
* 10+ years' experience in an IT operations environment performing database administration.
* 3+ years of experience with Azure portal and all topics in Azure related to database maintenance including SQLMI and AzureSQL with failover groups as well as Azure CLI
* 3+ years of experience with AWS portal including CLI, S3, EC2, EBS and infrastructure knowledge
* 3+ years of experience with SQL Server Always On Availability Groups
* PowerShell Scripting experience
* Deep knowledge of SQL internal functionality including but not limited to
* Query Processing and Optimization
* Reading and Analyzing Execution plans, table statistics, data distribution and execution times
* Indexing Mechanisms
* Types, Maintenance and impact
* Transaction Management
* Isolation levels, Locking mechanisms, deadlocks, etc.
* Storage Architecture
* Data Pages, filegroups, row/page compression, etc.
* Expert in large database design (logical, physical, conceptual) for OLTP and data warehouse environments using the Microsoft platform.
* Backup and Recovery
* Backup types, Recovery Models, PITR, Disaster Recovery Planning, etc.
* Experience with maintaining high availability SQL environments and Disaster Recovery Strategies.
* Security and Access Control
* Authentication, Encryption, auditing, access requirements, etc.
* Monitoring and Performance Tuning
* Wait Statistics, Dynamic Management Views, Query Store, etc.
* Experience with Datadog, Elastic or New Relic
* Maintenance and Housekeeping
* Database Consistency checks, statistics updates, index maintenance, log file management.
* Experience using SQL Server Agent to develop and schedule administration jobs, alerts and groups.
* Effective analytical, communication, interpersonal and problem-solving skills.
* No management experience is required.
Preferred education and experience:
* Knowledge in Snowflake Administration
* Knowledge and experience working on Azure Cloud, Azure SQL and SQL Managed Instance is a plus
* Knowledge in Azure resources such as Storage Accounts, Blob Storage, Keyvault, Azure Active Directory
Additional eligibility requirements:
* An achiever, self-starter, and eager to learn
* You'll have a proven track record of results as we'll expect you to act decisively, think big, and manage your time and your team's time to meet deadlines in a fast-paced, high-volume environment.
* Most importantly, you'll want to contribute to a diverse, supportive, and talented team.
Travel required:
* Travel is potential to be 10% of time
Affirmative Action/EEO statement:
defi SOLUTIONS is an Equal Opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status.