Job Description
On a day-to-day basis, this individual will be responsible for administrating and implementing database solutions while providing system operational support, administration, problem resolution, and perform software installations and upgrades on our database systems concentrating on Google Cloud Platform and other cloud-based solutions (up to 30%). The Database Administrator will be expected to exhibit strong troubleshooting techniques while striving to maintain a high level of customer satisfaction. Other duties also include monitoring performance and capacity on our database systems.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Our employees are tasked with delivering excellent business results through the efforts of their teams. These results are achieved by:
- Responsibility for all enterprise database technology deployed in the cloud including various versions of Microsoft SQL Server and other database platforms including features such as the core database engine, reporting, data loading and transformations, business intelligence, replication technologies and other modules. Perform configuration and maintenance of database platforms, including patching.
- Monitor database instances for performance, utilization, and capacity. Work with application teams when appropriate to address issues.
- Manage maintenance plans, backups, and automated jobs.
- Responsible for the database platform security model, including using Active Directory-integrated accounts in a multi-forest setting where appropriate.
- Responsible for query writing and optimization.
- Responsible for database schema design.
- Develop, administer, and optimize Google BigQuery datasets, tables,
views, partitioning, clustering, permissions, scheduled queries, and data pipelines to support reporting, analytics, and operational workloads.
- Responsible for advising report writers and their deployment in various reporting solutions or writing reports when needed.
- Support BigQuery SQL development, performance tuning, cost optimization, data governance, access controls, and integration with Google Cloud services, business intelligence tools, and enterprise data platforms.
- Use typical database, cloud, monitoring, and DevOps tools such as Google Cloud Console, BigQuery, Cloud SQL, Cloud Storage, Cloud Monitoring, Cloud Logging, Dataflow, Dataproc, Looker, Tableau, SQL Server Management Studio, Visual Studio Code, Git, CI/CD release tools, PowerShell, Python, and ticketing or incident management platforms.
- Apply experience with AI agents and automation tools to improve database operations, including monitoring, incident triage, knowledge retrieval, documentation generation, operational workflows, and data-driven self-service capabilities.
- Responsible for performing traces and profiling to analyze and troubleshoot problems.
- Determine the best way to improve performance, whether through hardware adjustments, server configuration changes,
or index and query changes.
- Understanding of software development methodologies, software development lifecycle management, and working in an Agile/SCRUM environment with software development teams, providing consultative advice on database design and query optimization, including indexes.
- Familiarity with DevOps tools for managing releases.
- Familiarity with code repository tools for managing SQL objects as code with version control.
- On-call support for after-hours issues required. Leverage automated alerting to be notified of issues as they happen. Tune alerts to reduce noise.
- Responds to incoming phone, email, or web-reported technical issues from internal users related to network and infrastructure, and assists in troubleshooting database issues as well as application issues for which the database may be a contributing factor.
- Identifies severity and impact and documents details in the Help Desk call tracking system.
- Performs database monitoring to ensure service level agreements are met and alerts appropriate IT staff and management of any downtime.
- Works in partnership with all IT teams to find solutions, and/or escalates issues to appropriate IT groups for resolution.
- Communicates status and updates to end users in a timely and consistent manner.
- Sets priorities for open issues and escalates issues to the correct department for resolution.
- Follows through with closure of user issues.
- Recreates problems in development environments for troubleshooting and resolution when needed.
- Creates and documents workarounds.
- Assist in training.
📌 Google Cloud Database Administrator (Pune)
🏢 EVERSANA
📍 Pune