Database Administrator
- InfoVision Inc
- 8 - 12 years
- Bengaluru
- 4 months ago
- Email to a friend
- Report this job
Job Description
Critical Skills to Possess:
- Proven experience as a Database Administrator, with extensive knowledge of database technologies including PostgreSQL, SQL Server, Oracle, MySQL, and particularly AWS database services.
- Strong hands-on experience with relational SQL and NoSQL databases, such as PostgreSQL, and cloud database services.
- Deep understanding of database security, backup and recovery, and cost optimization strategies.
- Excellent analytical, problem-solving, and organizational skills.
- Ability to prioritize effectively in a fast-paced environment.
Preferred Qualifications:
- BS degree in Computer Science or Engineering or equivalent experience
Roles and Responsibilities
Roles and Responsibilities:
Strategic Database Management:
- Develop and implement strategies for improving the structure and efficiency of Invencos databases.
- Collaborate with IT and engineering teams to ensure the database architecture meets the current and future needs of our cloud systems.
- Lower - level admin details like Partitions, indexing , fragmentation, shading .
- Keep the DB house kept; manage back-up large table, create back-up scripts with FK-PF references
- Hunt the costly queries and fix them without impacting business.
AWS Cloud Solutions Implementation:
- Lead the design and deployment of robust data solutions and pipelines on the AWS Cloud Platform, optimizing database performance across various environments.
Data Management:
- Handle large-scale data sets, both structured and unstructured, and develop an understanding of how to manage and utilize these resources effectively.
- Continuous Integration/Continuous Deployment (CI/CD):
- Utilize CI/CD principles and DevOps methodologies within the database management lifecycle to enhance data delivery and operational efficiency.
- Advanced Database Knowledge:
- Apply expertise in data modeling, SQL/NoSQL databases, data structures, and ETL processes to improve database setups and operations.
- Indexing, partitioning, handling large table sizes and prescribing strategies for keeping the operational size in check.
Technology Proficiency:
- Experience with data integration tools, ETL frameworks, and data pipeline orchestration tools such as AWS Glue and AirFlow (Nice to have)
- Familiarity with Snowflake and dbt is advantageous but not mandatory.
Communication:
- Demonstrate excellent verbal and written communication skills, facilitating clear and effective interactions across the organization.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: InfoVision IncLocation(s): Bengaluru
Keyskills: cd continuous integration backup analytical database security ci/cd relational sql recovery sql sql azure database data modeling oracle dba backup and recovery database creation cost optimization data structures etl etl process nosql databases communication skills
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in