Overview
Skills
Job Details
Position : Lead DBA
Location : Iselin, NJ
Required Skills:
Key Responsibilities:
- Administration & Maintenance
- Manage installation, configuration, patching, and upgrades for SQL Server, Oracle, MongoDB, and mainframe databases (e.g., DB2).
- Monitor database health, performance, and capacity; perform tuning and optimization as needed.
- Implement and manage backup/recovery processes and disaster recovery strategies.
- Security & Compliance
- Ensure database security through user role management, access controls, and encryption standards.
- Support compliance with internal security policies and regulatory frameworks (e.g., SOX, HIPAA, GDPR).
- Development & Support
- Collaborate with application teams to support database development needs (e.g., stored procedures, triggers, indexing).
- Provide advanced troubleshooting for performance and operational issues.
- Automate administrative tasks using scripts (e.g., PowerShell, Shell, Python).
- Data Migration & Integration
- Support data integration and ETL processes between heterogeneous databases.
- Lead or assist in database migrations (e.g., on-prem to cloud or between platforms).
- Mainframe DB Support
- Administer mainframe database systems like IBM DB2.
- coordinate with mainframe support teams for batch processing, job control, and performance tuning.
Required Skills & Qualifications:
- 12-15+ years of experience as a DBA supporting multiple database platforms.
- Expertise in: Microsoft SQL Server (2016+), Oracle (12c/19c), MongoDB (sharded/replicated setups) and Mainframe DBMS (e.g., IBM DB2)
- Strong proficiency in SQL and database scripting.
- Familiarity with database monitoring and alerting tools
- Experience with high availability and disaster recovery (e.g., Always On, Data Guard, replica sets).
- Knowledge of cloud platforms (Azure) is a plus.
- Strong analytical and communication skills.
Alchemy: Transforming Your Professional Vision into Reality
Since our inception in 2013, Alchemy has been dedicated to reshaping organizational performance through innovative IT services. With a vision to empower businesses seeking a transformative edge, we ve positioned ourselves at the forefront of digitization and software modernization.
Our name reflects our mission: to transmute technology into gold-standard solutions for our esteemed clients. We proudly serve a diverse range of sectors, including IT and ITES, BFSI, Telecom and Media, Automotive, Manufacturing, Energy, Oil and Gas, Real Estate, Retail, Healthcare, and more.
With a global footprint spanning the USA, India, Europe, Canada, Singapore, Japan, and parts of Central and West Africa, we harness a unique blend of competencies, frameworks, and cutting-edge technologies. Together, we drive growth and innovation across industries, helping organizations turn their visions into reality.
Alchemy Connecting Talent with Opportunities (Diversity, Equity and Inclusion)