Tech Specialist

Yantran LLC

Atlanta, GA

JOB DETAILS
SKILLS
Analysis Skills, Automation, Business Support, Capacity Management, Change Management, Contingency Plans, Corrective Action, Data Recovery, Database Administration, Database Architecture, Database Replication, Disaster Recovery, Distributed Computing, Failover, Forecasting, High Availability, Identify Issues, Information/Data Security (InfoSec), Linux Operating System, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Operating System, Operating Systems, Oracle, Oracle 11i, Oracle Database, Oracle PL-SQL, Organizational Skills, Performance Management, Performance Tuning/Optimization, Python Programming/Scripting Language, Replication and Remote Mirroring, Resource Utilization, Risk Analysis, Risk Management, Root Cause Analysis, SAP, SQL (Structured Query Language), Server Support, Service Level Agreement (SLA), Software Patches, System Integration (SI), Technical Leadership, Unix Shell Programming, Windows PowerShell
LOCATION
Atlanta, GA
POSTED
30+ days ago
Role Summary:
The Senior Data Solution Engineer is responsible for providing technical leadership and operational oversight for enterprise Oracle and SQL Server database platforms supporting SAP and non SAP environments. This role serves as the primary onsite escalation point and technical authority for database architecture, performance, availability, and resiliency, ensuring stable, secure, and compliant database operations within a managed services environment.
Key Responsibilities:
Provide end to end infrastructure level support for enterprise databases including Oracle and SQL Server.
Ensure high availability, performance, and stability of database platforms in line with agreed SLAs.
Lead resolution of critical (Sev1/Sev2) incidents and drive service restoration
Own Problem Management activities, including root cause analysis and preventive actions.
Design, review, and validate database architecture solutions based on business, performance, and availability requirements.
Define and govern high availability and disaster recovery architectures (e.g., clustering, replication, failover strategies).
Experience with Oracle HA and DR solutions, including Oracle Data Guard for standby and failover architectures and Oracle GoldenGate for real time data replication and data sync, supporting business continuity and SR requirements.
Strong hands on experience of Oracle performance diagnostic tools including AWR, ASH, ADDM, SQL profiler, and execution plan analysis.
Hands on experience in installing, configuring, and maintaining Oracle (11g/12c/19c/21c) and Microsoft SQL Server (2016/2017/2019/2022) database platforms.
Proficiency in PL/SQL, T SQL, and SQL with scripting experience in Shell scripting and PowerShell, and exposure to basic Python for automation.
Strong experience administering databases on Linux and Windows operating systems, which solid understanding of OS level concepts required for Oracle and SQL server performance, availability, and troubleshooting.
Proven experience in implementing and managing backup and recovery strategies using Oracle and SQL Server backup and restore mechanisms, ensuring data protection and recovery readiness.
Strong expertise in distributed system and data integration architecture, supporting reliable, scalable, and resilient data platforms across all the application platforms.
Provide architectural input for new application onboarding, platform enhancements, and modernization initiatives.
Ensure database designs align with infrastructure standards, security requirements, and compliance policies.
Perform advanced performance tuning and troubleshooting at database and platform levels.
Analyze resource utilization and define capacity planning and growth forecasting models.
Proactively identify performance risks and scalability constraints.
Plan, review, and approve database patching, upgrades, and maintenance activities.
Ensure changes follow established change management processes and risk mitigation practices.
Validate rollback and contingency plans for critical maintenance activities.
Define and oversee backup, recovery, and disaster recovery strategies.
Ensure backup integrity, periodic recovery testing, and DR readiness.
Act as the technical authority during recovery and DR events.
*** is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin or disability. All applicants will be evaluated solely on the basis of their ability, competence, and performance of the essential functions of their positions with or without reasonable accommodations. Reasonable accommodations also are available in the hiring process for applicants with disabilities. Candidates can request a reasonable accommodation by contacting the company ADA Coordinator at
***
.

About the Company

Y

Yantran LLC