RedIron logo
RedIron

A retail systems integrator that helps you design, implement, integrate and maintain any major retail software platform.

Senior Database Administrator & Ops Engineer

Database AdministratorDatabase AdministratorOtherRemoteSeniorTeam 51-200H1B No SponsorCompany SiteLinkedIn

Location

Massachusetts

Posted

109 days ago

Salary

$0

Seniority

Senior

Bachelor Degree9 yrs expEnglishLinuxOracle DatabasePostgreSQL

Job Description

Senior Database Administrator & Ops Engineer

RedIron

Company Description We are a retail systems integrator and software provider that helps you design, implement, integrate and maintain any major retail software platform - legacy or cutting edge. Clients engage us when They want to dramatically improve their client experience without having the endure the cost and risk of replacing a core retail IT system. They need to achieve business outcomes leveraging ancient legacy systems AND cutting-edge technologies. Our depth, experience and FOCUS on the retail industry make us unique and different in this space. We have completed over 1,000 technology projects in North American retail and bring that experience and expertise to each new one. http://www.RedIron.com Job Description Test databases, correct errors, and make necessary modifications. Plan, coordinate, and implement security measures to safeguard information in files. Modify existing databases and database management systems. Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions. Perform all aspects of Oracle database administration. Actively participate in the daily Operational activities of customer databases. Monitor production, test, and development database environments and actively pursue any issues limiting the performance, scalability, and availability of these systems. Database bug resolution, address database security vulnerabilities. Analyze trends, report potential problems or areas of improvement concerning internal and customer databases. Performance tuning by analyzing Oracle AWR, ADDM, ASH reports. Setup, Configure and support Physical Standby (Active Data Guard) databases for high availability with proficiency in failover/switchover mechanisms. Setup, Configure Oracle database backups via Recovery Manager (RMAN) utility for Disaster recovery. Manage Database users, roles, and privileges. Provide Technical support to Customers. Plan Database refreshes from Production to non-prod environments to test application changes. Engineer migration plan for Oracle Databases from on-premises environments to AWS and devise suitable approach. Improve Database query workflow via implementing Oracle Table partitioning. Work on Oracle Export Import Utility (Classical & Data Pump) for Object level granular migration. Validate Oracle Database objects code and error corrections. Engineer parameters modifications in Database Management Systems. Automate Statistics collection against Enterprise Database servers to ensure Data dictionary views/tables/schemas are all current. Work closely with DevOps teams to review CPM backups periodically and to establish continuous delivery to Development teams. Devise learning curve via Test cases/Database Proof of Concepts. Participate in Managed Services on-call rotation. Qualifications

Job Requirements

  • B.S. degree in Computer Science, Information Systems or related field plus 5 years of experience with Oracle databases and knowledge of Oracle database 10g/11g/12c and Oracle Middleware (Weblogic) 11g/12c, Oracle PSU patching, Oracle Database Performance tuning, Oracle Active Data Guard, Oracle database backups via Recovery Manager (RMAN), Oracle Table partitioning, Oracle Export Import Utility, Linux Shell Scripting, Postgres RDBMS.
  • Additional Information
  • MULTIPLE POSITIONS AVAILABLE. Telecommuting available, work remotely from anywhere in the United States. Resume to: RedIron, 42 Fletcher Hill Lane, Groton, MA  01450

Related Categories

Related Job Pages

More Database Administrator Jobs

OtherRemoteTeam 10,001+Since 1962H1B No Sponsor

• Perform application and database management and maintenance activities • Support routine maintenance including problem defect analysis and resolution • Support and monitors system performance diagnosing software and hardware failures to resolution • Support service outages, including backups and restores • Support patch management and distribution capabilities • Perform data cleansing services, verify data integrity, and implement access controls • Support database configuration, monitoring, and tuning • Support logs and alerts, access rights and roles • Supports Systems Development, Migration, and Integration efforts

United States
$90.3K - $189.6K / year
Job Closed
Concept Plus, LLC logo

Senior Oracle Admin

Concept Plus, LLC

Transforming Concepts Into Solutions

OtherRemoteTeam 51-200H1B No Sponsor

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description Concept Plus is seeking a Senior Oracle Admin to assist in coordinating the delivery of client capabilities alongside internally maintained services, ensuring both accessibility and usability. - Responsible for building and integration of multiple Oracle Fusion Middleware services in the Oracle Cloud Infrastructure. - Assist in defining requirements, designing, building, troubleshooting, and testing efforts. - Thorough understanding of Oracle Fusion Middleware products and architecture, especially Oracle identity management and its integration with Oracle EBS. - Installation, maintenance, securing, performance tuning Oracle identity suite. - Provide support for other middleware products (SOA, WLS, OEM, …). - Experience with administration of RAC databases and OCI environment is a plus. - Modify existing software to correct errors, adapt to new hardware, or to improve its performance. - Analyze user needs and software requirements to determine feasibility of design within time and cost constraints. - Confer with others to design systems and to obtain information on project limitations and capabilities, performance requirements and interfaces. - Store, retrieve, and manipulate data for analysis of system capabilities and requirements. - The Senior Database Administrator administers organization's databases, using database management systems to organize and store data. - The Senior Database Administrator ascertains user requirements, creates computer databases, and tests and coordinates changes. - This individual interacts with development and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases. - Ability to work productively in a team environment and participate as a positive and cooperative team member. - Strong verbal, written, organizational and documentation skills. Qualifications - US Citizen - Active Secret Clearance - Bachelors Degree Required - 7+ years’ experience implementing and troubleshooting - Experience with the following tools: Oracle Identity Suite, Oracle Fusion Middleware, OIAM Implementations, Oracle Analytics Server, patch assessment, system administration, Linux operating systems, OE Linux - Strong verbal, written, organizational and documentation skills. - Active CompTIA Security+ Certification - Active IASAE L2 certification (i.e. CISSP, CCNA, CAP, CASP+ CE, CCISO, CND, CSSLP, CYSA+, GSLC, SSCP) Company Description Concept Plus is an Affirmative Action/Equal Opportunity Employer. As such, we will give your application full consideration without regard to your race, color, religion, sex, age, national origin, disability, veteran status, sexual orientation, gender identity, or any other classification protected by federal, state, or local law.

United States
Job Closed

NOTE: We are currently not hiring employees residing in the state of CA or NY. 10Y professional experience required. Salary Range: $120k-$145k DOE. Job Description: Are you ready to take your SQL skills to the next level? Join SQLWatchmen as a Senior Database Administrator - Tier 2 and become a key player in our fully remote team! You'll be at the forefront of supporting customers’ production and dev SQL servers and supporting and guiding Tier 1 DBAs. This role is perfect for someone who thrives on diagnosing technical issues, has a passion for performance tuning, enjoys being part of an on-call rotation, and loves communicating with both the team and customers. Who We Are: At SQLWatchmen, we pride ourselves on delivering best-in-class MS SQL Server support with unrivaled customer service. With over 17 years in the business, our CEO and founder's passion for MS SQL Server spans more than two decades. We are deeply committed to our culture and seek employees and customers who resonate with our core values: - Be A Partner - Stay Curious - Take Ownership - Help First - Find Joy in the Work If these values speak to you, we want to hear from you! Our DBA Team: Join our dynamic, fully remote small team of seasoned professionals with a current average of over 22y experience each in MS SQL Server.  Some of us have earned the SQLSkills Black Belt certification and you’ll have the chance to achieve this prestigious certification too! What This Role Requires of You: ·         Proactive Monitoring: Keep an eye on SQL Servers and resolve issues via the ticketing system (CW PSA) before they escalate. Escalate tickets to Tier 3 support when necessary. ·         Technical Expertise: Showcase your advanced technical and T-SQL programming skills. ·         Performance Tuning: Fine-tune indexes and rework queries for optimal performance. ·         HA/DR Strategies: Develop, maintain, and monitor high availability and disaster recovery strategies (Clusters, Mirroring, AlwaysOn, Replication, Log Shipping). ·         Security: Ensure data and access to SQL Server are secure. ·         SQL Programming: Demonstrate advanced technical and programming skills. ·         Replication: Design, implement, and maintain data warehouses/ODS systems using SQL Server Replication, SSIS, SSAS, and T-SQL scripting. ·         On-Call Rotation: Participate in the on-call rotation (PagerDuty) for emergency coverage. When on-call, respond to text messages within 1 hour. ·         Communication: Keep the team and customers informed about incident progress, changes, and outages. ·         PostgreSQL Enthusiasm is a Plus: Have some experience with PostgreSQL and a desire to dive deeper. ·         Administrative Tasks: Enter time and expenses in ConnectWise PSA, attend scheduled meetings, and complete training materials in a timely manner.

United States
MetLife logo

IAM Database Intelligence Engineer

MetLife

MetLife is a leading insurance and financial services company based in New York, New York. The company and its affiliates specialize in employee benefits and life, accident, and he

OtherRemoteTeam 43,000Since 1868

Description and Requirements How You'll Help Us Build a Confident Future (Key Responsibilities) Develop and Maintain Automation frameworks using Python, Pandas, Flask, PyTest. Develop microservices or applications involving RESTful APIs and data connectivity to existing data platforms. Build and enhance Python ETLs which ingest and process internal REST APIs. Experience with Azure, particularly in relation to data storage, integration, processing, and AI services. Hands-on experience in developing and optimizing EL (Extract and Load) processes using ADF (Azure Data Factory). Perform unit, integration, and functional testing of developed components. Deploy the developed services/modules in a Docker containerized environment. Adress issues and apply necessary fixes or enhancements. Implement reliable, scalable, and high performing distributed systems. Collaborate with cross functional team for feature development and system improvements. Experience with Cl/CD pipelines and version controls in GIT. Experience with containerization tools such as Docker and orchestration tools like Kubernetes. Experience with RESTful and GraphQL API's. Understanding of data warehousing concepts and best practices including optimization strategies, query tuning, and clustering. Knowledge of data visualization tools like Power BI or Tableau for creating dashboards. Experience with message driven architectures and event sourcing. Knowledge of Agile methodologies and Tool. Experience with testing frameworks (e.g. Junit, Pytest). Required Skills: Bachelor's degree in computer science, Information Systems, or another related field with 6+ years of Python or similar development tools OR high school diploma or equivalent and 7+ years' Python or similar development tools experience. Understanding of Regulatory, NIST practices and Access management risks and controls. Most of the following tool experience: Python, Pandas, Flask, PyTest, Django, Angular JS, GraphQL, React.js, Lambda, AWS S3 bucket integration, GitLab, Docker, Elastic Load Balancer, Azure Data Factory. Preferred Skills: Process automation and optimization experience. Experience with Large Language Models (LLMs) and Agentic frameworks. Additional database platform experience with Oracle, UDB, IMS, MS SQL, AS400. 4+ years of IT work experience in information systems support, security administration, risk management, and/or audit principles. The expected salary range for this position is $100,000 - $145,000. This role may also be eligible for annual short-term incentive compensation. All incentives and benefits are subject to the applicable plan terms. Benefits We Offer Our U.S. benefits address holistic well-being with programs for physical and mental health, financial wellness, and support for families. We offer a comprehensive health plan that includes medical/prescription drug and vision, dental insurance, and no-cost short- and long-term disability. We also provide company-paid life insurance and legal services, a retirement pension funded entirely by MetLife and 401(k) with employer matching, group discounts on voluntary insurance products including auto and home, pet, critical illness, hospital indemnity, and accident insurance, as well as Employee Assistance Program (EAP) and digital mental health programs, parental leave, volunteer time off, tuition assistance and much more! About MetLife Recognized on Fortune magazine's list of the "World's Most Admired Companies", Fortune World's 25 Best Workplaces™, as well as the Fortune 100 Best Companies to Work For®, MetLife, through its subsidiaries and affiliates, is one of the world's leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East. Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by our core values - Win Together, Do the Right Thing, Deliver Impact Over Activity, and Think Ahead - we're inspired to transform the next century in financial services. At MetLife, it's #AllTogetherPossible . Join us! MetLife is an Equal Opportunity Employer. All employment decisions are made without regards to race, color, national origin, religion, creed, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity or expression, age, disability, marital or domestic/civil partnership status, genetic information, citizenship status (although applicants and employees must be legally authorized to work in the United States), uniformed service member or veteran status, or any other characteristic protected by applicable federal, state, or local law ("protected characteristics"). If you need an accommodation due to a disability, please email us at accommodations@metlife.com. This information will be held in confidence and used only to determine an appropriate accommodation for the application process. MetLife maintains a drug-free workplace. It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liabilities. $100,000 - $145,000

United States
$100K - $145K / year
Job Closed