SQL Database Administrator — Edison, NJ
Зарплата не указана
ОткликнутьсяnGXTqfFr C9Wh 34pj. is the largest retailer-owned cooperative in the United States and supports its co-operative members' retail operations, trading under the ShopRite, Price Rite Marketplace, The Fresh Grocer, Dearborn Market, Gourmet Garage, Fairway Market, and Di Bruno Bros.
Employing an innovative approach to wholesale business services, azkTyv6R focuses on helping the independent retailer compete in a big business world. Providing the tools entrepreneurs need to stay a step ahead of the competition, xzu8aJnH’C co-operative members benefit from the company’s extensive portfolio of services, including innovative technology, private label development, and best-in-class procurement practices.
About You
Summary
We are seeking a highly skilled Senior Database Administrator (DBA) to provide technical leadership and operational support across enterprise database platforms spanning both legacy and modern technology environments. This role requires deep expertise in Microsoft SQL Server with exposure to modern cloud-based data platforms and data modernization initiatives.
The ideal candidate will possess strong experience supporting mission-critical, high-volume transactional systems while helping guide the evolution of enterprise data platforms toward cloud-native and analytics-driven architectures, including PostgreSQL, Google Cloud Platform (GCP), and BigQuery.
Essential Functions
Database Administration & Operations
• Provide senior-level administration and operational support for Microsoft SQL Server and cloud-based database platforms.
• Install, configure, upgrade, patch, monitor, and maintain enterprise database environments.
• Ensure database availability, reliability, security, and performance across supported platforms.
• Support backup, recovery, disaster recovery, and high-availability solutions.
Performance Optimization
• Analyze and tune database performance across large-scale production environments.
• Optimize SQL statements and application database interactions.
• Perform execution plan analysis and access path reviews.
• Develop and maintain effective indexing strategies.
• Manage statistics collection, database maintenance activities, capacity planning, and resource optimization.
Database Engineering & Support
• Design and implement database solutions supporting enterprise applications.
• Manage and maintain database objects including tables, indexes, views, stored procedures, packages, constraints, and security controls.
• Troubleshoot complex production issues and conduct root cause analysis.
Collaboration & Modernization
• Partner with application development, integration, infrastructure, and data engineering teams.
• Support enterprise modernization efforts involving migration and integration of legacy database platforms into cloud environments.
• Provide guidance on database architecture, governance, standards, and best practices.
• Evaluate emerging database technologies and recommend modernization strategies.
Additional Functions
• PostgreSQL administration and support.
• IBM DB2 for z/OS admiration and support.
• Google Cloud Platform (GCP), BigQuery, Cloud Storage, and cloud-native data services.
• Hybrid cloud and on-premises data architectures.
• Database migration, replication, and modernization programs.
• Enterprise ETL, data integration, and data pipeline technologies.
• Data warehousing and analytical processing environments.
• Database replication technologies.
• Database automation and monitoring tools.
• Infrastructure-as-Code (IaC) and cloud operations concepts.
• API-driven and event-driven data architectures.
• Collaboration with development teams on database design and application optimization.
Qualifications
• Bachelor's degree in computer science, Information Technology, or related field, or equivalent experience.
• 10+ years of enterprise database administration experience.
• Experience administering Microsoft SQL Server including installation and configuration, performance tuning, backup and restore, security and access management, production support, and troubleshooting.
• Install, configure, upgrade and patch SQL Server instances (2016 through 2022) in development, test
and production.
• Build and maintain high-availability and disaster-recovery solutions: Always On Availability Groups,
Failover Cluster Instances, log shipping and replication.
• Design, automate and regularly test backup and recovery plans that meet the required recovery
point and recovery time objectives (RPO/RTO).
• Monitor database health, capacity and performance, and fix issues before they affect the business.
• Tune performance using execution plans, indexing strategy, Query Store, wait statistics and DMVs,
and resolve blocking and deadlocks.
• Manage database security: logins, roles, least-privilege access, TDE, Always Encrypted and auditing.
• Work with developers on schema design, T-SQL code reviews, release deployments and query
optimization.
• Automate routine tasks with PowerShell (dbatools), T-SQL and SQL Server Agent.
• Support migrations to Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure
VMs.
• Maintain runbooks, standards, configuration documentation and environment inventories.
• Support audit and compliance requirements (such as SOX and PCI), including access reviews and
evidence collection.
• Join the on-call rotation and lead root-cause analysis for database incidents.
• Advanced SQL skills with the ability to analyze complex workloads and optimize performance.
• Experience supporting highly available, mission-critical transactional systems.
Working Conditions & Physical Demands
• Availability to work a varied, flexible schedule to meet business demands
• Ability to monitor computer screens for long periods of time
• Ability to work a hybrid schedule as established by the division (4 days on-site, 1 day remote)
Core Competencies
• Communicate Effectively: Communicates thoughts and ideas in a well-organized manner, encouraging two-way communication.
• Build Relationships: Creates cross-functional partnerships through the development and maintenance of constructive and cooperative relationships.
• Stay Competitive: Demonstrates a mindset of continuous improvement while exhibiting passion and enthusiasm for their work.
• Embrace Change: Looks for new ways of working by supporting advancements in processes and technology.
• Develop You: Identifies and capitalizes on opportunities for personal and professional career growth.
• Drive for Results: Supports divisional and strategic objectives through achievement of work goals.