IBM Certified Tivoli Administrator
360 It Professionals
Columbus, OH
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. Qualifications Qualification: • 2+ years' experience - Installing and configuring IBM Tivoli Storage manager server versions 5.x, 6.x and 7.x on windows server environment. • 2+ years' experience - Planning and upgrading IBM Tivoli Storage manager server V6.x instances and V5.x instances. • 2+ years' experience - Installing TSM server fix packs. • 2+ years' experience - Install and configure TSM monitoring and reporting feature. • 3+ years' experience - Planning and configuring TSM Database, Active log, Active Log Mirror, Archive log and Failover archive log for TSM instances. • 3+ years' experience - Configuring TSM Library manager, TSM library client instances and setting up server to server communication. • 3+ years' experience - Configuring and sharing the tape libraries IBM TS3500 and IBM 3494 across TSM Library manager and TSM library client instances. • 6+ years' experience - Defining Random access disk storage pools, sequential access disk storage pools, sequential access tape pools for TSM Primary storage pools and TSM copy storage pools. • 6+ years' experience - Configuration of TSM server components like domain, policy set, mgmt class, copy groups and Define backup/archive policies to keep the number of versions of client Files. • 6+ years' experience - Configuring TSM administrative features like Migration, Backup storage pool, TSM Database backup, Expire inventory and reclamation and move data. • 4+ years' experience - Work with TSM backup sets/export-import process to create/restore long term tapes. • 3+ years' experience - Install TSM client software on windows, Red Hat Linux operating systems and configure dsm.opt, Client scheduler service on the client nodes. • 6+ years' experience - Using Backup archive client to do backup/archive and complete any client restores. • 6+ years' experience - Handling day-to-day TSM activities like TSM Client scheduling, TSM admin schedules, monitoring of database, log, storage pools and offsite volumes, Identify and troubleshoot any TSM server, TSM Client backup, restore, scheduler and performance related issues. • 6+ years' experience - Design, Implement TSM Disaster Recovery feature and work with DRM plan files, TSM database restore, Storage pool restore etc and completing client data restores at DR Site. • 2+ years' experience - Writing TSM SQL queries, TSM admin scripts and TSM macros. • 2+ years' experience - Manage TSM licensing. • 2+ years' experience - Work with Vendor to open service tickets to troubleshoot any issues with hardware and TSM software. • 2+ years' experience - Document the standards and procedures for installing and configuring TSM servers, TSM Clients and DRM process as required. Certification:- • IBM Certified Administrator - Tivoli Storage Manager V6 Additional Information Webcam interview is acceptable$46k-72k yearly est. 10h agoDatabase Administrator 2-IT
Oracle
Columbus, OH
Building off our Cloud momentum, Oracle has formed a new organization - Oracle Health Applications & Infrastructure. This team will focus on product development and product strategy for Oracle Health while building out a complete platform supporting modernized, automated healthcare. This is a net new line of business, constructed with an entrepreneurial spirit that promotes an energetic and creative environment. We are unencumbered and will need your contribution to make it a world-class engineering center with a focus on excellence. The Healthcare platform is an exciting team working at the intersection of infrastructure and applications, leveraging OCI to transform some of the largest healthcare applications in the industry. We are making healthcare better for everyone. To support this vision, we are building a platform that manages the end-to-end lifecycle, from provisioning to upgrade to termination. Providing a self-service cloud experience to the customer, we are looking for passionate Database Administrators who are Oracle Database, Oracle Cloud, and Oracle Autonomous Database experts. We seek Database Administrators with current experience in cloud technologies or those interested in expanding their skills in the Cloud. **Responsibilities** As a Database Administrator, you will be responsible for managing Oracle Health Applications & Infrastructure Databases (Prod & Non-Prod), performing basic database monitoring, and capacity management. You will triage database alerts and issues, identify root causes, and implement corrective actions. Additionally, you will be responsible for managing, maintaining, and supporting healthcare Non-production, Standby, Golden Gate, and Production databases, including setting up and maintaining database backups and monitoring and maintaining database replication. You will apply database software updates and stand-alone hotfixes to customer environments, communicate with third-party software or hardware manufacturers as needed to ensure optimal configuration and support. Candidates should have good knowledge of Oracle Database architecture, Backup and Recovery, Data Guard, Real Application Clusters, ASM, Data Pump, Patching, Performance, and SQL Tuning. You will also develop standardized work plans, documentation, processes, and automation. Willingness to work additional hours as needed and allowed by local regulations is essential. The primary focus is to keep the lights on, ensuring customer databases are stable and performant to fulfill our contractual obligations to customers. Additionally, you will be part of the OHAI roadmap projects, such as migrating the Database to Oracle Cloud and Autonomous Databases **Minimum Qualifications** + At least 3+ years of experience as Oracle DBA + 1+ years of experience shipping scalable, cloud native distributed systems. + Bachelor's degree/master's degree (Information Technology/Mathematics/Computer Science/Computer Software/Electronics/Operational Research/Computer System Engineering). + Ability to work in a collaborative, cross-functional team environment. + Strong grasp of Computer Science concepts + Knowledge in Python, Perl and/or Shell Scripting + Managing production databases running on UNIX flavors (RHEL, OEL). **Skills** : + Oracle Database + Oracle Grid Infrastructure, ASM & RAC + Oracle Cloud **Preferred Qualifications** **:** + Oracle Maximum Availability Architecture & Exadata. + High availability & replication technologies (Data guard, Goldengate) + Advanced scripting/coding skills (Shell, Perl, and Python) + Oracle Autonomous Database Disclaimer: **Certain US customer or client-facing roles may be required to comply with applicable requirements, such as immunization and occupational health mandates.** **Range and benefit information provided in this posting are specific to the stated locations only** US: Hiring Range in USD from $30.29 to $60.63 per hour; from: $63,000 to $126,100 per annum. May be eligible for equity. Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business. Candidates are typically placed into the range based on the preceding factors as well as internal peer equity. Oracle US offers a comprehensive benefits package which includes the following: 1. Medical, dental, and vision insurance, including expert medical opinion 2. Short term disability and long term disability 3. Life insurance and AD&D 4. Supplemental life insurance (Employee/Spouse/Child) 5. Health care and dependent care Flexible Spending Accounts 6. Pre-tax commuter and parking benefits 7. 401(k) Savings and Investment Plan with company match 8. Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation. 9. 11 paid holidays 10. Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours. 11. Paid parental leave 12. Adoption assistance 13. Employee Stock Purchase Plan 14. Financial planning and group legal 15. Voluntary benefits including auto, homeowner and pet insurance The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted. Career Level - IC2 **About Us** As a world leader in cloud solutions, Oracle uses tomorrow's technology to tackle today's challenges. We've partnered with industry-leaders in almost every sector-and continue to thrive after 40+ years of change by operating with integrity. We know that true innovation starts when everyone is empowered to contribute. That's why we're committed to growing an inclusive workforce that promotes opportunities for all. Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs. We're committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing accommodation-request_************* or by calling *************** in the United States. Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans' status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.$63k-126.1k yearly 39d agoDBA DB2 - Level III
Sonsoft
Marysville, OH
SonSoft Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. SonSoft Inc is growing at a steady pace specializing in the fields of Software Development, Software Consultancy, and Information Technology Enabled Services. Job Description Coordinates professional staff including recommending, starting, organizing, selecting or recommending selection, training, assigning and evaluating work and counseling Monitors trends and improvements in database technology laws, rules, and client policy to plan database improvements, expansions, and future requirements: assists in establishment of goals, objectives, policies, procedures, and quality standards Manages database operations by coordinating with directors, selected and appointed officials, and others to determine requirements, establishing and encouraging work or project teams, developing work schedules, reviewing performance information, monitoring projects, and reporting on significant activities and events. Assists database users by providing or overseeing training, assisting with database problems, addressing requirements for new capabilities, installing upgrades, and providing other assistance as required. Oversees database system administration such as system documentation, configuration management, backup, security, access, virus protection, performance information, and related tasks Performs department administrative functions such as preparing budgets, controlling expenditures, performing special studies, preparing reports, providing support to elected or appointment officials and boards or communities and preparing specifications for contracts Daily Tasks Performed: Design, model, configure, test, and install DB2 databases in the test, development, and production environments Perform and troubleshoot database backup, recovery, capacity, and security plans Administer, maintain, and implement changes to existing databases to meet customer requirements Respond to test and production database problems and implement immediate resolution efforts across technology areas Musts: BA/BS in Information Technology, Computer Science or related field or equivalent work experience Negotiates and exchanges ideas, information, and opinions with others to formulate policy and programs or arrive jointly at decisions, conclusions, or solutions Performs work involving the application of logical principles and thinking to solve practical problems within or applying to a unit or division of the organization Reads professional literature and technical manuals; speaks to groups of employees and or public or private groups: writes manuals and complex reports Performs professional level work requiring the application of principles and practices of a wide range of administrative and technical or managerial methods. Qualifications 5 - 7 years' experience in DB2 and other DBA related skills More than 5 years' experience as a DB2 LUW DBA 2 years' experience as a database developer Experienced in large-scale system implementations and projects ++ Good communication skills Additional Information Connect with me at ******************************************* ( For Direct Clients Requirements ) ** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time. Note:- This is a Contract job opportunity for you. Only US Citizen , Green Card Holder , GC-EAD , H4-EAD, L2-EAD & TN-Visa can apply. No OPT-EAD & H1B candidates, please. Please mention your Visa Status in your email or resume . ** All your information will be kept confidential according to EEO guidelines.$83k-107k yearly est. 10h agoDigital & IT Senior Analyst
Parker-Hannifin, Corporation
Elyria, OH
Responsibilities Are you ready to shape a brighter future? In Motion Systems Group and Hydraulic Valve Systems Division, we play a pivotal role in applications that change our world. We are in almost everything that moves. With our wide range of technologies, we help our customers solve their most complex engineering challenges by living our purpose: enabling engineering breakthroughs that lead to a better tomorrow. We believe that our team members are our key assets and that a diverse workforce is a driving force to bring our purpose to life. We foster a culture where every team member feels safe, included and empowered. We all belong, we all matter, and we all make a difference. We have an exciting opening for a Digital & IT Senior Analyst in Elyria, OH. This position defines, configures, tests, trains and supports business-related information technology requirements and systems. Collaborating with Group and Division subject matter experts and 3rd party IT vendors, they lead directly, or co-lead, single technology or regional IT projects with accountability for completing on time, budget and meeting expectations. Your main responsibilities * Leads directly, or co-leads, complex and/or global digital and IT project tasks delivering business results that meet deadlines; provide guidance to project resources within and across multiple teams as needed * Ability to communicate technical insights effectively to both technical and non-technical stakeholders, aligning data analysis with business KPIs. * Proficient in relational database design, normalization, schema management, and SQL query optimization. * Strong T-SQL skills for writing complex stored procedures, functions, triggers, with experience in debugging, error handling, and deployment. * Experienced in designing, developing, and deploying SSIS packages, including ETL processes, control/data flow, error handling, and performance tuning. * Knowledgeable in Azure Data Factory, Azure Synapse, and Databricks for modern data integration and processing. * Skilled in Power BI Desktop, Power Query, and DAX for data transformation, visualization, report publishing, and managing data security. * Strong analytical skills with expertise in data cleaning, validation, statistical analysis, and interpreting trends using BI tools like Power BI and Excel. * Familiar with Agile methodologies, including experience leading teams and serving as Scrum Master to drive collaboration and project delivery. * Solid understanding of database backup, recovery, security, transaction management (ACID), and data modeling tools. * Experienced in package deployment, scheduling with SQL Server Agent, version control, and maintaining data governance best practices. * Ability to travel as needed * Available to provide after-hours technical support as needed We are looking for a talent with * Bachelor's degree in computer science, information systems, or related area (Or international equivalent) * 4+ years related IT experience * Excellent written and verbal communication and collaboration skills * Strong interpersonal skills, relates well with all levels of the organization * Demonstrated leadership aptitude, learning agility, and adaptability * Demonstrated ability to lead teams and manage projects effectively Parker Hannifin Parker Hannifin is a Fortune 250 global leader in motion and control technologies. For more than a century, we've enabled engineering breakthroughs that make energy cleaner, transportation safer, medical treatments more effective, and manufacturing more efficient. With empowered team members in more than 40 countries, Parker serves customers across aerospace & defense, energy, HVAC & refrigeration, in-plant & industrial equipment, off-highway and transportation. Our scale is global, but our purpose is personal. We enable breakthroughs that improve lives, strengthen communities and create a brighter future. Our Purpose - Enabling Engineering Breakthroughs that Lead to a Better Tomorrow - comes to life through our people-first culture where teamwork drives performance, inclusion fuels innovation and growth is encouraged. This environment fosters collaboration and empowers team members from engineering and manufacturing to finance, supply chain, human resources, information technology and beyond. By combining deep expertise with an entrepreneurial spirit, we help customers succeed in markets that demand performance, reliability, and sustainability. As we look to the future, Parker is advancing initiatives in energy efficiency and sustainability while developing the next generation of talent and leaders to engineer a better tomorrow. Equal Employment Opportunity Parker is an Equal Opportunity and Affirmative Action Employer. Parker is committed to ensuring equal employment opportunities for all job applicants and employees. Employment decisions are based upon job related reasons regardless of race, ethnicity, color, religion, sex, sexual orientation, age, national origin, disability, gender identity, genetic information, veteran status, or any other status protected by law. However, U.S. Citizenship, Permanent Residency or other appropriate status is required for certain positions, in accord with U.S. import & export regulations. ("Minority / Female / Disability / Veteran / VEVRAA Federal Contractor") If you would like more information about Equal Employment Opportunity as an applicant under the law, please go to Employees & Job Applicants | U.S. Equal Employment Opportunity Commission Drug Tests Drug-Free Workplace In accordance with Parker's policies and applicable state laws, Parker provides for a drug-free workplace. Therefore, all applicants seeking employment with Parker will be subject to drug testing as a condition of employment.$91k-109k yearly est. 44d agoBackup Admin
Krg Technology
Cincinnati, OH
Backup (L2 / L3) · History with solid resources like NetBackup Command Line ADIC Tape Libraries UNIX System Administration and NetApp VTL devices · Knowledgeable in creating backups for enterprise environments · Configuring EMC Networker server and coupling it with EMC data domain and VBA. · Configuring CommCell and its allied media agents. · Configuring CIFS and NFS shares from storage boxes to servers. · Capacity Planning -Backup data growth planning & procurement. · Identify opportunities for improving system performance in terms of backup time optimizing, minimize errors. · Providing solutions based on RPO and RTO standards. · Performing bare metal recovery and other form of restore operations at crisis. · Designing EBR environment for backups from VMware vSphere. · Managing MSSQL database backup and restore through NMM and Database agents. · Configuring schedule, storage policies and resource pools for backup. · Configuring storage resources and media agents in Commcell Additional Information All your information will be kept confidential according to EEO guidelines.$75k-115k yearly est. 60d+ agoOracle DBA (Remote)
Conexess Group
Remote job
Our History: From our start in 2009, Conexess has established itself in 3 markets, employing nearly 200+ individuals nation-wide. Operating in over 15 states, our client base ranges from Fortune 500/1000 companies to mid-small range companies. For the majority of the mid-small range companies, we are exclusively used due to our outstanding staffing track record. Who We Are: Conexess is a full-service staffing firm offering contract, contract-to hire, and direct placements. We have a wide range of recruiting capabilities extending from help desk technicians to CIOs. We are also capable of offering project-based work. Conexess Group is aiding a large healthcare client in their search for an Oracle DBA in a remote capacity. This is a long-term opportunity with a competitive compensation package. ******We are unable to work C2C on this role****** Responsibilities: Review of SQL and PL/SQL code to identify performance issues, in-depth knowledge of SQL and PL/SQL is a must. Provide consultation to Application Development teams on SQL and PL/SQL best practices. Extensive experience leading troubleshooting calls with various infrastructure and application teams. Efficiently work with Oracle vendor to find root cause for complex database issues. In-Depth knowledge of Oracle wait events to troubleshoot complex performance issues is a must. In-depth knowledge in Linux and storage internals that influence database activity is a must. Install and manage Oracle Database Software, build databases per requirements and standards, and set up database backups. Install and manage Oracle ClusterWare and troubleshoot issues with ClusterWare processes. Experience with database migrations, export/import and transportable tablespaces. Proficient with restoring and recovering of oracle databases using RMAN is required, must be able to restore databases from block corruptions and logical corruptions, and recover the database to Point-In-Time. Apply Quarterly Patches to Database, Standalone Grid Infrastructure, and ClusterWare and troubleshoot any issues with patching (requires good understanding of the oracle internal processes). Setup and Manage Oracle Enterprise Manager (OEM) Infrastructure, and setup monitoring using OEM for database environments. Automation of routine database operations using Ansible, with broad understanding of CI/CD tools. Participate in 24*7 On-call support to resolve Incident tickets and be responsible for database Qualifications: 8+ years of relevant experience and knowledge of Oracle database administration with oracle 11g, 12c, 19c, Oracle RAC, dataguard, goldengate and ASM in Linux is required. 3+ years of hands-on experience with Automation tools and technologies like Ansible, GitHub, and similar CI/CD technologies. Knowledge in AWS and Python is a plus Strong collaboration skills and experience working across multiple teams both within a division and enterprise-wide Strong technical acumen, able to ensure that technical solutions, strategies, practices, and governance deliver business and customer value Development experience with one or more modern scripting/automation languages (Ansible, Python, etc.) - preferred #LI-Remote #LI-CB2$75k-103k yearly est. 60d+ agoDatabase Administrator Server Engineer
Akron Children's Hospital
Akron, OH
Full Time 40 Hours/Week Monday - Friday, 8am-4:30pm On-Call Rotation Required The Database Administrator / Server Engineer is responsible for the administration, support, and optimization of SQL and Epic Caché databases and Linux-based server infrastructure within a healthcare environment. This role ensures the stability, security, and performance of mission-critical systems that support clinical and operational functions. The position involves installation, configuration, monitoring, and maintenance of databases and servers, with a focus on data integrity, system availability, and compliance with healthcare regulations. The role requires collaboration with application, infrastructure, and security teams to support system upgrades, troubleshoot performance issues, and maintain a reliable environment aligned with HIPAA and organizational standards. Responsibilities: * Install, configure, and maintain SQL Server databases, perform regular database backups, restores, and maintenance tasks and monitor performance and tune SQL queries and indexes. * Ensure data integrity and security across all environments. * Implement and maintain high availability and disaster recovery strategies. * Perform basic Linux system maintenance (Red Hat/CentOS/Ubuntu), manage user accounts, file permissions, and basic shell scripting, patch and update system software and monitor system logs and maintain cron jobs and troubleshoot OS-level issues. * Perform basic administration of EPIC Cache environments and monitor Cache database health and performance metrics. * Collaborate with EPIC support teams to troubleshoot Cache-related issues and maintain documentation for Cache systems and interfaces. Other information: Technical Expertise * Exposure to EPIC Cache or InterSystems Cache environments (training or direct experience a plus). * Strong troubleshooting and documentation skills. * Ability to work independently and as part of a team Education and Experience * Education: Bachelor's degree in computer science, Information Systems, or related field; or equivalent experience * Licensure: None * Certification: Microsoft Certified: Azure Database Administrator Associate or Linux+ or RHCSA or Epic Cache Admin Certification preferred * Years of relevant experience: Minimum of 3 years of experience with SQL Server (2016 or later) in an administrative capacity and at least one year of experience with Linux system administration. * Years of supervisory experience: None Full Time FTE: 1.000000$89k-106k yearly est. 11d agoNeed Backup Admin at Cincinnati, OH
Krg Technology
Cincinnati, OH
KRG has been consistently recognized and appreciated by renowned multibillion dollar clients for being their trusted staffing partners for more than a decade. If interested, please check out the here below and share your updated resume. For further queries please call or share a good time to connect. Job Description Job Title: Backup Admin Location: Cincinnati, OH Duration: Full Time Backup (L2 / L3) · History with solid resources like NetBackup Command Line ADIC Tape Libraries UNIX System Administration and NetApp VTL devices · Knowledgeable in creating backups for enterprise environments · Configuring EMC Networker server and coupling it with EMC data domain and VBA. · Configuring CommCell and its allied media agents. · Configuring CIFS and NFS shares from storage boxes to servers. · Capacity Planning -Backup data growth planning & procurement. · Identify opportunities for improving system performance in terms of backup time optimizing, minimize errors. · Providing solutions based on RPO and RTO standards. · Performing bare metal recovery and other form of restore operations at crisis. · Designing EBR environment for backups from VMware vSphere. · Managing MSSQL database backup and restore through NMM and Database agents. · Configuring schedule, storage policies and resource pools for backup. · Configuring storage resources and media agents in Commcell Mandatory: LinkedIn presence and for verification share 2 good references from your last two projects. If you are not interested in the role or if now isn't a great time for a move, just let me know if I can help in the future. Thanks & Regards, Disclaimer: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. 2If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Additional Information All your information will be kept confidential according to EEO guidelines.$75k-115k yearly est. 60d+ agoDBA DB2 Consultant
Sonsoft
Marysville, OH
Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services. Job Description Job Responsibilities: · Coordinates professional staff including recommending, starting, organizing, selecting or recommending selection, training, assigning and evaluating work and counseling · Monitors trends and improvements in database technology laws, rules and client policy to plan database improvements, expansions and future requirements: assists in establishment of goals, objectives, policies, procedures, and quality standards · Manages database operations by coordinating with directors, selected and appointed officials, and others to determine requirements, establishing and encouraging work or project teams, developing work schedules, reviewing performance information, monitoring projects, and reporting on significant activities and events · Assists database users by providing or overseeing training, assisting with database problems, addressing requirements for new capabilities, installing upgrades, and providing other assistance as required · Oversees database system administration such as system documentation, configuration management, backup, security, access, virus protection, performance information, and related tasks · Performs department administrative functions such as preparing budgets, controlling expenditures, performing special studies, preparing reports, providing support to elected or appointment officials and boards or communities and preparing specifications for contracts Daily Tasks Performed: · Design, model, configure, test, and install DB2 databases in the test, development, and production environments · Perform and troubleshoot database backup, recovery, capacity, and security plans · Administer, maintain, and implement changes to existing databases to meet customer requirements · Respond to test and production database problems and implement immediate resolution efforts across technology areas Musts: · BA/BS in Information Technology, Computer Science or related field or equivalent work experience · Negotiates and exchanges ideas, information, and opinions with others to formulate policy and programs or arrive jointly at decisions, conclusions, or solutions · Performs work involving the application of logical principles and thinking to solve practical problems within or applying to a unit or division of the organization · Reads professional literature and technical manuals; speaks to groups of employees and or public or private groups: writes manuals and complex reports · Performs professional level work requiring the application of principles and practices of a wide range of administrative and technical or managerial methods. Qualifications Experience: · 5 - 7 years' experience in DB2 and other DBA related skills · More than 5 years' experience as a DB2 LUW DBA · 2 years' experience as a database developer · Experienced in large scale system implementations and projects ++ Good communication skills Additional Information Note:- This is a Full-Time & Permanent job opportunity for you. Only US Citizen , Green Card Holder , GC-EAD , H4-EAD & L2-EAD can apply. No OPT-EAD, H1B & TN candidates please. Please mention your Visa Status in your email or resume .$83k-107k yearly est. 10h agoSenior Lead Teradata Database Administrator, Remote
Unitedhealth Group
Remote job
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._$110.2k-188.8k yearly 60d+ agoSenior Lead Teradata Database Administrator, Remote
Unitedhealth Group Inc.
Remote job
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.$110.2k-188.8k yearly 60d+ ago