Job Information
Ensono Senior Database Administrator in Pune, India
Senior Database AdministratorPune, IndiaJR010518
About Us (Ensono)
Ensono is an expert technology adviser and managed service provider. As a relentless ally, we accelerate clients’ digital transformation to achieve business outcomes that stand to last. Our dedicated team helps organizations optimize today’s systems across any hybrid environment with services such as consulting, mainframe and application modernization, public cloud migration and cloud-native development. With certified experts in AWS, Azure and Google Cloud and recognized as Microsoft Datacenter Transformation Partner of the Year, Ensono has over 3500+ associates globally and is headquartered in greater Chicago.
We care about your success, offering comprehensive strategic and managed services for mission-critical applications. Our Advisory and Consulting services can help upfront with an application strategy or find the right places for your applications – whether it’s public, multi or hybrid cloud, or mainframe. And because we span across all mission-critical platforms, we can meet you wherever you are in your digital transformation journey, with 24/7 support when you need it. We are your relentless ally, flexing with you when challenges emerge so you don’t feel stuck in place. With cross-platform certifications and decades of experience, our technology experts have become an extension of your team so you’re continuously innovating – doing more with less while remaining secure. And that’s just the beginning.
About Role
The Database Administrator creates, maintains, designs, monitors and troubleshoots Ensono or client databases. They use specific relational database management systems, develop and implement database recovery mechanisms and procedures. And coordinate security measures to safeguard database integrity.
Roles and responsibilities
Consistently provides proven, formal mentorship
High complexity assignments – owner
Moderate complexity assignments – owner (1 or >)
Low complexity assignments – provide oversight/review
Regularly lead self and others and/or established as Product SME and/or established as specialist
Understands how whole picture aligns to overall Ensono strategy
Installation and configuration of database software and related products
Plans and implements Database backup and recovery
Implementing robust change control and configuration management policies
Capacity planning & system-level architecture
OS/Storage/DB configuration and optimization
Database security checks and audits, including compliance-related reporting & controls
General database health checks
Database monitoring
Working with DBMS vendor support (Oracle support, Microsoft support, etc.)
Defining and maintaining quantitative SLAs and helping enhance current service levels
Physical data model/architecture, DDL generation and maintenance
DB server migrations and decommissioning
Database creation and configuration
Applying patches
Upgrading the databases
Maintenance (proactive, reactive and automated); both scheduled and unscheduled
Database refreshes
Improve processes and procedures
Log-file review
Complex trouble-shooting and repairs
Reporting on state of databases
Database tuning (proactive and reactive)
Maintaining specialized environments such as log shipping, replication, cluster-based instances, etc.
SOP (Std. Operating Procedure) definition & automation
DBMS and related tools license management
Documentation related to all Systems DBA areas
Management of database-related tools (monitoring systems, tool repositories, etc.)
Automated measurement of quantitative SLAs & any deviations thereof
Development & utilization of detailed triage processes
Detailed workload analysis
Infrastructure advise and planning
Disaster recovery/failover services
Working with Developers
Ensuring the availability of the database
Managing database users and security/access control
Contributes significant, new and innovative ideas to the DBA knowledge base
Architect complex database solutions
On-call
Qualifications:
Typically requires a minimum of 5 years of related experience with a Bachelor’s degree; or 6 years and a Master’s degree; or a PhD with 3 years experience; or equivalent work experience
Analytical
Organizational
Complex Problem Solving
Documentation
Ability to Multi-task
Strong Relational Database
SQL
UNIX
Windows
Strong Database Administration and Performance Tuning
Coaching Skills
Leadership
Ability to work independently
Logical /Physical Database Design
Preferred
Bachelor’s degree and a minimum of 5 years of related experience; or equivalent work experience
JR010518