Senior Database Administrator jobs at National MI - 7 jobs

--------------------------------------------------------------- The IS Database Developer II is responsible for developing and maintaining database and ETL processes, as well as recommending and partnering in the design and development of effective solutions in support of business strategies. This role is essential toward maturing CareOregon's database and ETL development model. This position spends substantial time evaluating, architecting, and implementing IS priorities (plan, design, install, and maintain). Estimated Hiring Range: $111,690.00 - $136,510.00 Bonus Target: Bonus - SIP Target, 5% Annual Current CareOregon Employees: Please use the internal Workday site to submit an application for this job. --------------------------------------------------------------- Essential Responsibilities Database Development Actively participate in the design of custom databases and processes. Provide advanced database design support to the organization; lead small projects with assistance from Supervisor or Lead and participate and consult on other projects. Collaborate with other IS teams on best practices of database design and development. ETL Development Develop ETL processes for moderate to advanced activities. Develop moderate to advanced databases to meet application and web needs. Analyze business requirements; research and recommend solutions which include potential risks and mitigation. Develop and maintain appropriate technology documentation, including current design and operation. Standards and Policy Administration Propose requirements, standards and best practices for database and ETL development. Participate in the ongoing review of existing systems to ensure they are designed to comply with established standards and to empower business operations. Vendor Coordination and Relations Conduct product and vendor research, and present recommendations to more advanced database developers and/or management. Establish and maintain effective working relationships with vendors and related equipment suppliers, including installation and repair of services. Experience and/or Education Required Minimum 3 years of database and ETL development required. Experience should include some or all of the following: Database development and maintenance ETL development and maintenance Systems analysis and design Agile/Scrum methodology Note: For data warehouse focused roles, minimum 3 years' experience developing ETL for loading a dimensional model using a combination of T-SQL and SSIS 2012, 2014, or 2016 Preferred Bachelor's degree in Computer Science, Information Systems, or a related field Additional experience in related technology support and/or operational positions QNXT experience Knowledge, Skills and Abilities Required Knowledge Working knowledge/skills with the following: Microsoft SQL Server ETL tools, such as SSIS or Informatica Visual Studio Unit and integration testing Note: For data warehouse focused roles, advanced knowledge/skills of the dimensional model required in lieu of knowledge/skill requirements above General knowledge of BizTalk (preferred) Skills and Abilities Advanced abilities in troubleshooting system performance issues and root cause Effective communication skills, including listening, verbal, written, and customer service Ability to clearly articulate policies and instructions Demonstrated progress in conveying appropriate level of detail effectively to all levels of the organization including non-technical staff Ability to recommend policies, document risks, and propose solutions to information technology management and senior leadership Possess a high degree of initiative and motivation Ability to effectively collaborate with coworkers, staff, and leaders across all departments Ability to work effectively with diverse individuals and groups Ability to learn, focus, understand, and evaluate information and determine appropriate actions Ability to accept direction and feedback, as well as tolerate and manage stress Ability to see, read, and perform repetitive finger and wrist movement for at least 6 hours/day Ability to hear and speak clearly for at least 3-6 hours/day Working Conditions Work Environment(s): ☒ Indoor/Office ☐ Community ☐ Facilities/Security ☐ Outdoor Exposure Member/Patient Facing: ☒ No ☐ Telephonic ☐ In Person Hazards: May include, but not limited to, physical and ergonomic hazards. Equipment: General office equipment Travel: May include occasional required or optional travel outside of the workplace; the employee's personal vehicle, local transit or other means of transportation may be used. Work Location: Work from home We offer a strong Total Rewards Program. This includes competitive pay, bonus opportunity, and a comprehensive benefits package. Eligibility for bonuses and benefits is dependent on factors such as the position type and the number of scheduled weekly hours. Benefits-eligible employees qualify for benefits beginning on the first of the month on or after their start date. CareOregon offers medical, dental, vision, life, AD&D, and disability insurance, as well as health savings account, flexible spending account(s), lifestyle spending account, employee assistance program, wellness program, discounts, and multiple supplemental benefits (e.g., voluntary life, critical illness, accident, hospital indemnity, identity theft protection, pre-tax parking, pet insurance, 529 College Savings, etc.). We also offer a strong retirement plan with employer contributions. Benefits-eligible employees accrue PTO and Paid State Sick Time based on hours worked/scheduled hours and the primary work state. Employees may also receive paid holidays, volunteer time, jury duty, bereavement leave, and more, depending on eligibility. Non-benefits eligible employees can enjoy 401(k) contributions, Paid State Sick Time, wellness and employee assistance program benefits, and other perks. Please contact your recruiter for more information. We are an equal opportunity employer CareOregon is an equal opportunity employer. The organization selects the best individual for the job based upon job related qualifications, regardless of race, color, religion, sexual orientation, national origin, gender, gender identity, gender expression, genetic information, age, veteran status, ancestry, marital status or disability. The organization will make a reasonable accommodation to known physical or mental limitations of a qualified applicant or employee with a disability unless the accommodation will impose an undue hardship on the operation of our organization.

FLSA Status: Exempt Department: Information Technology Reports To: Director, Infrastructure and Systems Support Employee Unit: Employees in this classification are represented by Service Employees International Union (SEIU) Local No. 521 The Systems Database Administrator is responsible for database security, integrity, performance, availability, and recoverability of databases, database servers, and related systems. In addition, the Systems Database Administrator is responsible for installing, configuring, and maintaining database servers, databases, related objects, and related software and for database security in support of SCFHP objectives and regulatory compliance. ESSENTIAL DUTIES AND RESPONSIBILITIES To perform this job successfully, an individual must be able to perform each essential duty listed below satisfactorily. * Provide technical management and support for the organization's database environments to ensure database security, integrity, performance, availability and recoverability of databases, database servers, and related systems. * Develop, implement, and periodically test backup and recovery plan for the production of critical databases to ensure the business continuity plan is accurate and effective. * Ensure database security by controlling access to databases through authentication and authorization and performing auditing of database usage and active users. * Audit database security and user access to ensure HIPPA regulatory law reporting requirements are met. * Monitor database server resources to ensure production environments meet performance and availability requirements. * Install, test, secure and maintain new versions of database software, patches and other associated software application changes or upgrades. * Provide storage and capacity planning, long and short term, to ensure adequate space is available for all database environments. * Document database architecture, including developing and maintaining database installation and configuration procedures, data governance program, change control deployment procedures, and SQL coding guidelines. * Work with the application development team to ensure that appropriate and efficient SQL is coded and tested prior to production deployment. * Perform other related duties as required or assigned. REQUIREMENTS - Required (R) Desired (D) The requirements listed below are representative of the knowledge, skill, and/or ability required or desired. * Bachelor's Degree in Computer Science, or related field, or equivalent experience, training or coursework. (R) * Minimum three years of experience serving as a systems database administrator in a Microsoft SQL Server environment with versions currently supported by Microsoft. (R) * Microsoft Certified Solutions Expert (MCSE). (D) * Minimum three years of experience maintaining multiple database environments and regions to support production, development and test areas of business systems; including managing database security, database tuning, query optimization, and application code deployment. (R) * Minimum three years of experience SQL Scripting and Command Shell scripting. (R) * Minimum three years of experience with any of the following applicable languages/platforms: .NET, PERL, Java, SAS, VB, C++, or other modern programming language or related software. (R) * Minimum three years of experience with MS SQL Business Intelligence tools (SSRS, SSIS, SSAS) or other enterprise business intelligence software. (R) * Experience maintaining a data warehouse database environment, including managing and enforcing data governance and coding best practice. (R) * Ability to create and maintain documentation of source code, application installation processes, technical specifications, and data governance program. (R) * Working knowledge of and the ability to efficiently operate all applicable computer software including computer applications such as Outlook, Word and Excel. (R) * Ability to use a keyboard with moderate speed and a high level of accuracy. (R) * Excellent communication skills including the ability to express oneself clearly and concisely when providing service to SCFHP internal departments, providers and outside entities over the telephone, in person or in writing. (R) * Ability to think and work effectively under pressure and accurately prioritize and complete tasks within established timeframes. (R) * Ability to assume responsibility and exercise good judgment when making decisions within the scope of the position. (R) * Ability to maintain confidentiality. (R) * Ability to comply with SCFHP's policies and procedures. (R) * Ability to perform the job safely with respect to others, to property, and to individual safety. (R) WORKING CONDITIONS Generally, duties are primarily performed in an office environment while sitting or standing at a desk. Incumbents are subject to frequent contact with and interruptions by co-workers, supervisors, and plan members or providers in person, by telephone, and by work-related electronic communications. PHYSICAL REQUIREMENTS Incumbents must be able to perform the essential functions of this job, with or without reasonable accommodation: * Mobility Requirements: regular bending at the waist, and reaching overhead, above the shoulders and horizontally, to retrieve and store files and supplies and sit or stand for extended periods of time; (R) * Lifting Requirements: regularly lift and carry files, notebooks, and office supplies that may weigh up to 5 pounds; (R) * Visual Requirements: ability to read information in printed materials and on a computer screen; perform close-up work; clarity of vision is required at 20 inches or less; (R) * Dexterity Requirements: regular use of hands, wrists, and finger movements; ability to perform repetitive motion (keyboard); writing (note-taking); ability to operate a computer keyboard and other office equipment (R) * Hearing/Talking Requirements: ability to hear normal speech, hear and talk to exchange information in person and on telephone; (R) * Reasoning Requirements: ability to think and work effectively under pressure; ability to effectively serve customers; decision making, maintain a concentrated level of attention to information communicated in person and by telephone throughout a typical workday; attention to detail. (R) ENVIRONMENTAL CONDITIONS General office conditions. May be exposed to moderate noise levels.

At Allstate, great things happen when our people work together to protect families and their belongings from life's uncertainties. And for more than 90 years, our innovative drive has kept us a step ahead of our customers' evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection. Job Description We are seeking a Senior Database Administrator (DBA) to provide strategic leadership in transforming our data landscape from a traditional on-premises SQL Server to a modern, cloud-based architecture leveraging Microsoft Azure and AWS platforms. This role will report into the Data Engineering team within the Investments Technology organization, driving innovation and operational excellence in database management. This position is a hybrid role, meaning your schedule may consist of time in an office setting and time working remotely from your home. The hybrid model is intended to provide greater flexibility - and will mean something different to each team, job and employee. Office presence is driven by the nature of the work and team needs. You'll work from home for the remainder of the time you're not in the office. This position is eligible for a monthly connectivity reimbursement to offset the costs of internet and phone expenses. Key Responsibilities KEY RESPONSIBILITIES Lead the Data Transformation Journey Drive migration from on-prem SQL Server to cloud platforms implementing scalable, secure, and high-performing databases. Team Mentorship Mentor a small team of DBAs, fostering a culture of collaboration, innovation, and continuous learning. Performance and Optimization Ensure optimal performance, availability, and security of databases across hybrid environments aligning to Allstate security requirements. Governance and Compliance Implement best practices for data governance, security, and compliance in cloud and hybrid setups aligning to Allstate security requirements. Collaboration Work closely with Enterprise engineering aligning Investments with enterprise data strategy. Work closely with Investments product and business teams aligning with organizational goals. ESSENTIAL SKILLS 10+ years in database administration with strong expertise in SQL Server (Oracle experience is a plus). 3+ years in Azure and/or AWS cloud platforms. Exposure to Microsoft Fabric and OneLake is a strong plus. Proven experience coaching DBA teams and driving large-scale database migrations. Database performance tuning, high availability, disaster recovery. Familiarity with Delta Lake, Parquet, and modern data architectures. Strong understanding of security and compliance in cloud environments. Excellent communication, stakeholder management, and strategic thinking. Supervisory Responsibilities This job does not have supervisory duties. Skills AWS Cloud Computing, AWS Cloud Computing, Business, Cloud Platform, Coaching, Collaboration, Compliance, Data Architecture, Database Administration, Database Design, Database Management, Database Management Systems (DBMS), Database Performance, Database Performance Tuning, Databasing, Data Engineering, Data Governance, Data Modeling, Data Strategies, Data Transformation, Enterprise Data, Enterprise Data Strategy, Investments, Microsoft Azure, Operational Excellence {+ 1 more} Compensation Compensation offered for this role is 98,100.00 - 167,850.00 annually and is based on experience and qualifications. The candidate(s) offered this position will be required to submit to a background investigation. Joining our team isn't just a job - it's an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger - a winning team making a meaningful impact. Allstate generally does not sponsor individuals for employment-based visas for this position. Effective July 1, 2014, under Indiana House Enrolled Act (HEA) 1242, it is against public policy of the State of Indiana and a discriminatory practice for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States, a member of the Indiana National Guard or a member of a reserve component. For jobs in San Francisco, please click “here” for information regarding the San Francisco Fair Chance Ordinance. For jobs in Los Angeles, please click “here” for information regarding the Los Angeles Fair Chance Initiative for Hiring Ordinance. To view the “EEO Know Your Rights” poster click “here”. This poster provides information concerning the laws and procedures for filing complaints of violations of the laws with the Office of Federal Contract Compliance Programs. To view the FMLA poster, click “here”. This poster summarizing the major provisions of the Family and Medical Leave Act (FMLA) and telling employees how to file a complaint. It is the Company's policy to employ the best qualified individuals available for all jobs. Therefore, any discriminatory action taken on account of an employee's ancestry, age, color, disability, genetic information, gender, gender identity, gender expression, sexual and reproductive health decision, marital status, medical condition, military or veteran status, national origin, race (include traits historically associated with race, including, but not limited to, hair texture and protective hairstyles), religion (including religious dress), sex, or sexual orientation that adversely affects an employee's terms or conditions of employment is prohibited. This policy applies to all aspects of the employment relationship, including, but not limited to, hiring, training, salary administration, promotion, job assignment, benefits, discipline, and separation of employment.

The basic function of the Optical Associate, Optician is to attract and retain customers by delivering exceptional customer service, fostering customer retention, and promoting outstanding associate/doctor satisfaction. Drive profitable store sales by fostering a customer care culture through practicing and using effective retail sales skills utilizing the Total Customer Experience Model Develop professional business relationships with other Associates, Host, and Doctor Fill ophthalmic eyeglass prescriptions and fit and adapt lenses and frames, including but not limited to the following: Utilizing optical prescription, evaluate prescription in conjunction with customer's visual requirements Recommend specific lenses, lens coatings, and frames to suit customer needs Assist customers in the selection of frames and coordinate frames with optical measurements and prescription Conduct measurements of bridge and eye size, temple length, vertex distance, pupillary distance, and optical centers using appropriate tools Ensure high quality through accurate measurements, correct pricing, and realistic delivery time quotes Maximize Managed Vision Care relationships and sales opportunities as measured by: Effective plan administration and local service Improvements in average transaction Locally initiated plans Assist with the timely implementation of approved Marketing programs by the execution of marketing programs and initiatives Ensure positive and productive host relationships through Host participation, support, and satisfaction measured by Patient Satisfaction Surveys Other duties as assigned by Optical Manager Job Specifications Typically has the following skills or abilities: If Required by State: Applicable State licensure or certification by a nationally recognized optician association as an optician Ability to sell through use of sales skills and accountability for sales results Experience and results with a retail or customer service establishment Ability to provide enthusiastic and concise communication to meet/exceed customer expectations as well as foster positive and results-oriented associate, doctor, and host relationships Success in store merchandising and attention to detail Minimum of 1-2 years of experience in related field Compensation range for the role is listed below. Applicable salary ranges may differ across markets. Actual pay will be determined based on experience and other job-related factors permitted by law. As a part of the compensation package, this role may include eligible bonuses and commissions. For more information regarding VSP Vision benefits, please click here. Salary Ranges: $23.00 - $34.77 VSP Vision is an equal opportunity employer and gives consideration for employment to qualified applicants without regard to age, gender, race, color, religion, sex, national origin, disability or protected veteran status. We maintain a drug-free workplace and perform pre-employment substance abuse testing. Unincorporated LA County Residents: Qualified Applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act, and any other similar laws. Notice to Candidates: Fraud Alert - Fake Job Opportunity Solicitations Used to Collect Fees/Personal Information. We have been made aware that fake job opportunities are being offered by individuals posing as VSP Vision and affiliate recruiters. Click here to learn about our application process and what to watch for regarding false job opportunities. As a regular part of doing business, VSP Vision (“VSP”) collects many different types of personal information, including protected health information, about our audiences, including members, doctors, clients, brokers, business partners, and employees. VSP Vision employees will have access to this sensitive personal information and are subject to follow Information Security and Privacy Policies.

The Director, Solutions Architecture will provide direction for enterprise technology strategies. This role is also responsible for all activities related to development of architectural designs and preliminary construction details. Adherence to established standards, timelines, code quality, requirement fulfillment and security are the responsibility of the role. The Director should have a deep knowledge of technology and functioning of the department to create strategies, objectives, policies, and procedures that support the functional infrastructure of the IT department. ESSENTIAL FUNCTIONS Develop and drive the overall architecture strategy with hands-on involvement in design, documentation, and implementation. Collaborate with tech teams and department leads to deliver complex projects which may involve multiple systems. Analyze, document, refine and maintain architectures that are developed within the team. Work closely with IT operations team to request, refine hardware requirements for existing and new systems. Create strategy and transition plans to deliver projects on time. Take ownership of executing technology roadmap to transition existing architecture to new, stable design. Work closely with Security team to tighten any security issues discovered in infrastructure. Meet Allied's expectations for productivity, quality, and goal accomplishment. Work closely with department lead to prioritize and strategize. Adhere to, and apply all applicable privacy and security laws, including but not limited to HIPAA, HITECH and any regulations promulgated thereto. Attend continuing education classes as required, including but not limited to HIPAA training. Lead, coach, motivate and develop. Responsible for one-on-one meetings, performance appraisals, growth opportunities and attracting new talent. Clearly communicate expectations, provide employees with the training, resources, and information needed to succeed. Actively engage, coach, counsel and provide timely, and constructive performance feedback. Perform other duties and responsibilities, as assigned. EDUCATION Bachelor's in computer science, Information Systems or a related field or equivalent work experience required. EXPERIENCE AND SKILLS At least 7 years' experience in architecting and supporting development of projects in Microsoft stack demonstrated sustained performance with impact at team(s) or department level required. At least 5 years at a manager level and successful demonstrated leadership competencies Ability to facilitate working architecture sessions with diverse participants including technical leaders and stakeholders. Hands on experience with developing system models, UML diagrams, workflow diagrams and detailed documentation to explain architectural blueprints. Experience with identifying technology needs and gaps, identifying potential solutions and alternatives. Strong background in SDLC, Agile, distributed systems, CI/CD, data engineering technologies, API Integration, and Micro/Mini/Macro services Deep knowledge of industry standards and best practices. Ability to train the development teams to follow and adhere to the practices. Ability to evaluate COTS or propose alternate home-grown solutions with budget, time, and scalability as guiding factors. Experience with orchestrating monitoring and alerting solutions for all systems. Ability to create an escalation process to prevent downtime and adhere to SLAs. Fluent in OOP, Design patterns, architectural principals Excellent analytical and organization skills Self-starter with high motivation and passion to learn, adapt constantly, evolve, and grow. Maintain high standards of data quality and integrity. Excellent verbal and written communication skills Experience developing and architecting containerized cloud-based solutions. Azure Certified or at least 2 years' experience with Microsoft Azure cloud environment. POSITION COMPETENCIES Communication Accountability Building Relationships/Shaping Culture Cost Awareness/Budgeting Leadership/Lead by Example Business Acumen Leading Innovation and Change PHYSICAL DEMANDS This is an office environment requiring extended sitting and computer work. WORK ENVIRONMENT Remote Here at Allied, we believe that great talent can thrive from anywhere. Our remote friendly culture offers flexibility and the comfort of working from home, while also ensuring you are set up for success. To support a smooth and efficient remote work experience, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 100Mbps download/25Mbps upload. Reliable internet service is essential for staying connected and productive. The company has reviewed this job description to ensure that essential functions and basic duties have been included. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills, and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate. Compensation is not limited to base salary. Allied values our Total Rewards, and offers a competitive Benefit Package including, but not limited to, Medical, Dental, Vision, Life & Disability Insurance, Generous Paid Time Off, Tuition Reimbursement, EAP, and a Technology Stipend. Allied reserves the right to amend, change, alter, and revise, pay ranges and benefits offerings at any time. All applicants acknowledge that by applying to the position you understand that the specific pay range is contingent upon meeting the qualification and requirements of the role, and for the successful completion of the interview selection and process. It is at the Company's discretion to determine what pay is provided to a candidate within the range associated with the role. Protect Yourself from Hiring Scams Important Notice About Our Hiring Process To keep your experience safe and transparent, please note: All interviews are conducted via video. No job offer will ever be made without a video interview with Human Resources and/or the Hiring Manager. If someone contacts you claiming to represent us and offers a position without a video interview, it is not legitimate. We never ask for payment or personal financial information during the hiring process. For your security, please verify all job opportunities through our official careers page: Current Career Opportunities at Allied Benefit Systems Your security matters to us-thank you for helping us maintain a fair and trustworthy process!

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start **Caring. Connecting. Growing together.** The DBA is responsible for the overall database delivery of the Enterprise Data Warehouse for the Medicaid agency. It is a critical role involving expertise in working with Medicaid data itself, security, supporting and maintaining hardware and software, and ensuring we are achieving optimal performance. For example, the DBA is expected to provide a wide range of expertise including the ability to help a user to fetch data (requiring business knowledge) and the technical ability to support a major Teradata upgrade. This role requires regular onsite presence in Springfield, Illinois to perform backup/restore and support onsite maintenance by Teradata (and its subcontractors). This position will be part of our Data Engineering function and data warehousing and analytics practice. Data Engineering Functions may include database architecture, engineering, design, optimization, security, and administration; as well as data modeling, big data development, Extract, Transform, and Load (ETL) development, storage engineering, data warehousing, data provisioning and other similar roles. Responsibilities may include Platform-as-a-Service and Cloud solution with a focus on data stores and associated eco systems. Duties may include management of design services, providing sizing and configuration assistance, ensuring strict data quality, and performing needs assessments. Analyzes current business practices, processes and procedures as well as identifying future business opportunities for leveraging data storage and retrieval system capabilities. Manage relationships with software and hardware vendors to understand the potential architectural impact of different vendor strategies and data acquisition. May design schemas, write SQL or other data markup scripting, and helps to support development of Analytics and Applications that build on top of data. Selects, develops, and evaluates personnel to ensure the efficient operation of the function. You'll enjoy the flexibility to work remotely * from anywhere within the U.S. as you take on some tough challenges. **Primary Responsibilities:** + Manage, monitor, and maintain OnPrem Teradata hardware/software including patches, replacements, and upgrades with support from Teradata + Support data governance, metadata management, and system administration + Plan and execute tasks required to ensure the Teradata system is operational including occasional evening and weekend support for Teradata maintenance + Provide direction to developers on Operational, Design, Development, and Implementation projects to ensure best use of the Teradata system including review/approval of database components (such as tables, views, SQL code, stored procedures) + Performing database backup and recovery operations - using the BAR DSA and NetBackup + Developing proactive processes for monitoring capacity and performance tuning + Providing day-to-day support for the EDW users problems like job hands, slowdowns, inconsistent rows, re-validating headers for tables with RI constraints, PPIs, and configuration + Maintaining rules set in the Teradata Active System Management (TASM) and supporting workload management + Maintaining the Teradata Workload Manager with the proper partitions and workloads based on Service Levels + Supporting the database system and application server support for the Disaster Recovery (DR) build/test, annual drill, and quarterly maintenance as needed + Actively monitoring the health of the Teradata system and Teradata Managed Servers (TMS) using Viewpoint and other tools and application servers and make preventive or corrective actions as needed + Maintaining access rights, role rights, priority scheduling, and reporting using dynamic workload manager, Database Query Log (DBQL), usage collections and reporting of ResUsage, AmpUsage, and security administration etc. + Coordinating with the team and customers in supporting database needs and making necessary changes to meet the business, contractual, security, performance, and reporting needs + Supporting internal or external audit process and address vulnerabilities or risk proactively + Prepare and support IRS and internal audit + Coordinating with Teradata to perform Teradata system hardening and delivery of Safeguard Computer Security + Evaluation Matrix (SCSEM) Reports as needed, addressing issues in the hardening and vulnerability scan report + Generating and maintaining capacity management, Space, and CPU reports on analyzing the Spool, CPU, I/O, Usage, and Storage resources and proactive monitoring to meet performance and growth requirements + Reviewing and resolving Teradata alerts and communicating any risk / issues or impact to the management, team, and business users through appropriate communication strategy + Effectively reporting status, future roadmap, proactive process improvements, automation, mitigation strategies, and compensating controls to the management and clients + Leading database or data related meetings and projects/activities delivering quality deliverables with minimal supervision/direction + Sharing knowledge, coaching/mentoring other members in the team for backups + Performing additional duties that are normally associated with this position, as assigned + Responsible for front-end tool (OpenText Bi-Query) and model maintenance and administration You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in. **Required Qualifications:** + 7+ years of experience as a Teradata DBA on Version 15+ (preferably 17+) and experience leading Teradata major upgrade/floor sweep + 5+ years of experience as primary/lead DBA with solid leadership and presentation skills + 5+ years of experience writing complex SQL using SQL Assistant/Teradata Studio + 3+ years of experience with Teradata 6800/1800 system or IntelliFlex + 3+ years of experience extracting, loading, and transforming structured/unstructured data using Teradata Utilities (FastLoad, Multiload, FastExport, BTEQ, TPT) in a Unix/Linux environment + 3+ years of experience performance tuning in a large database (>5TB) or data warehouse environment, using advanced SQL, DBQL and Explain plans + 3+ years of experience analyzing project requirements and developing detailed database specifications, tasks, dependencies, and estimates + 3+ years of experience identifying and initiating resolutions to customer facing problems and concerns associated with a query or database related business need + Data warehouse or equivalent system experience + Demonstrated excellent verbal/written communication, end client facing, team collaboration, mentoring skills, and solid work ethics + Demonstrated solid culture fit through integrity, compassion, inclusion, relationships, innovation, and performance **Preferred Qualifications:** + Teradata Vantage Certified Master + 5+ years logical and physical data modeling experience + 5+ years with Erwin or other data modeling software + 3+ years maintaining and creating models using OpenText BI-Query + 3+ years identifying and initiating resolutions to customer problems and concerns associated with a Data Warehouse or equivalent system + 3+ years working with end users/customers to understand requirements for technical solutions to meet business needs + 3+ years collaborating with technical developers to strategize solutions to align with business requirements + 3+ years defining standards and best practices and conducting code reviews + Experience working with project teams in metadata management, data/IT governance, business continuity plan, data security + Experience in Application Server Hardware/Software Administration (Windows/Linux) + Experience working in matrix organization as an effective team player + Experience working in agile environment such as Scrum framework and iterative/incremental delivery/release. + Experience in tools like DevOps and GitHub + Experience with State Medicaid / Medicare / Healthcare applications + Experience working in large Design Development and Implementation (DDI) projects + Experience upgrading to Teradata IntelliFlex + Knowledge/experience with Cloud databases such as Snowflake and migration from on Prem to Cloud project *All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with us, you'll find a far-reaching choice of benefits and incentives. The salary for this role will range from $110,200 to $188,800 annually based on full-time employment. We comply with all minimum wage laws as applicable. **Application Deadline:** This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants. _At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone-of every race, gender, sexuality, age, location and income-deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission._ _UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations._ _UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment._