Job description
Database Developer / Database Administrator (3–5 Years Experience)
Job Duties
• Monitor SQL Server instances for uptime, performance, and errors.
• Check SQL Agent jobs for failures and rerun as needed.
• Take adhoc backups for maintenance.
• Manage users, logins, and roles, including granting/revoking permissions.
• Perform basic troubleshooting for blocking and deadlocks.
• Write and optimize basic T-SQL queries (SELECT, INSERT, UPDATE, DELETE).
• Create and modify stored procedures, functions, and views.
• Re-run SQL queries to generate adhoc reports.
• Investigate slow-running queries using execution plans.
• Check SQL Server logs and Windows Event Viewer for errors.
• Resolve login failures, permission errors, or failed jobs.
• Track blocking sessions and escalate issues if needed.
Database Development & Reporting
• Design, develop, and maintain SQL Server databases, stored procedures, functions, triggers, and views.
• Write, optimize, and debug SQL scripts to support business requirements and automation.
• Build and maintain SQL scripts/jobs to generate daily/weekly/monthly reports for stakeholders in a real-time, high-availability environment.
Automation & Job Scheduling
• Create, configure, and monitor SQL Server Agent jobs to automate recurring tasks such as report generation, ETL, data validation, and system checks.
• Troubleshoot failed jobs and implement corrective actions to ensure reliability.
• Work with enterprise scheduling tools such as Control-M or ActiveBatch for job orchestration and workflow automation.
Database Administration
• Perform user management including provisioning, permissions, and role assignments through Active Directory (AD) integration.
• Support maintenance activities such as database backups, restores, index maintenance, and statistics updates.
• Monitor and optimize database performance, troubleshoot locking/blocking issues, and improve query efficiency to support real-time transaction processing.
Cloud & Cross-Platform Database Support
• Provide basic query support and troubleshooting for Oracleand MongoDB databases.
• Perform basic administration tasks on Linux servers, including log review and script execution.
• Gain exposure to cloud-hosted databases with AWS RDS (SQL Server/Oracle) and Azure SQL Database / Managed Instance for backup, monitoring, and migration activities.
Collaboration & Industry Knowledge
• Partner with development, infrastructure, and business teams to ensure database reliability, availability, and compliance.
• Assist with deployments, patching, and upgrades across on-premise and cloud environments.
• Document database processes, job flows, and troubleshooting procedures.
• Contribute to secure and efficient database operations in a payment industry environment, adhering to compliance, audit, and regulatory standards (e.g., PCI DSS).
Qualifications & Requirements
• Bachelor's degree in Computer Engineering, Information Technology, or a related discipline (minimum).
• 3–5 years of professional experience in database development and administration with strong focus on SQL Server.
• Strong skills in T-SQL, query optimization, indexing strategies, and debugging.
• Hands-on experience with SQL Server Agent jobs and database automation.
• Working knowledge of Oracle SQL/PL-SQL and MongoDB queries.
• Basic proficiency in Linux (commands and scripting).
• Familiarity with AWS RDS and Azure SQL Database / Managed Instance.
• Exposure to enterprise job schedulers such as Control-Mor ActiveBatch.
• Experience in real-time environments or the payment industry is a strong asset.
• Knowledge of compliance and security standards (e.g., PCI DSS) preferred.
• Any Microsoft Azure certification (e.g., Azure Database Administrator Associate, Azure Data Engineer) is a bonus.
• Strong troubleshooting, communication, and collaboration skills.
Required Skill Profession
Other General