Inside Sales Manager

Database Administrator Lead - PostgreSQL

ABOUT Ashnik

Established in 2009, Ashnik is a leading open-source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open-source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.

THE POSITION

Ashnik is looking for talented and passionate people to be part of the team for an upcoming project at client location.

RESPONSIBILITIES

· Monitoring database performance

· Optimizing Queries and handle escalations

· Analyse and assess the impact and risk of low to medium risk changes on high profile production databases

· Implement security features

· DR implementation and switch over

QUALIFICATION AND EXPERIENCE

· Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.

· Experience of working in a production support environment

· Engineering or Equivalent degree

· Passion for open-source technologies is desired

ADDITIONAL SKILLS

· Install & Configure PostgreSQL, Enterprise DB

· Technical capabilities PostgreSQL 9.x, 10.x, 11.x

· Server tuning

· Troubleshooting of Database issues

· Linux Shell Scripting

· Install, Configure and maintain Fail Over mechanism

· Backup - Restoration, Point in time database recovery

· A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.

· A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.

LOCATION: Bangalore & Mumbai

Experience: 7 yrs plus

Package: upto 20 LPA

What you need to have:

Responsibilities-

• Deliver technical strategies and solutions, application development, and end-users services
• Lead projects to implement new or enhance existing functionalities including articulating requirements and translating them into effective technical solutions
• Build and maintain strong relationships and partnerships with team members across globe and customer stakeholders
• Work collaboratively as a team player to develop mutually acceptable solutions, and act as a mentor to the team
• Solve problems and provide support, taking responsibility to make decisions when appropriate
• Effectively communicate with team members and customers, Be able to articulate technology to a non-technical audience
• Build relationships with technical team members in all offices
• Track and manage dependencies across lines of business and platforms, Maintain technical risks register with mitigations
• Create or maintain architectural artifacts like architectural overview, architectural decisions, integrations diagram, non-functional requirements
• Collaborate with other technical team members and create a forum for sharing knowledge
• Come up with innovative ideas to improve quality in delivery
• Deploy, administer and support Microservices components in a RedHat OpenShift environment
• Should be hands-on and be ready to write complex code while mentoring junior developers to learn
• Thrive in a fast-paced and dynamic work environment and lead by example

• 15-20 years experience working on projects utilizing: Java, Web Development/REST (preferably with Spring), Linux, JUnit, Mocking, Maven, JavaScript, GIT
• Experience in the following areas are preferred – Microservices, Spring Boot, Spring Security with OAuth2, SOAP and SOAP UI, Jenkins configuration, AngularJS, RedHat PaaS (RHEL, Kubernetes, OpenShift, Camel, Fuse)
• Well versed in front end and back end development
• Good understanding of encryption technology
• Knowledge of infrastructure especially cloud infrastructure is desirable
• Should be conversant with DevOps methodologies
• At least 3 years of experience as a technical lead – coaching, presenting architectural/design elements to customers and team members
• Should possess strong problem solving and analytical skills
• Should have experience reviewing code for team members and etching out a concrete code quality plan
• Should have at least two years of experience working on projects using Test Driven Development (TDD)
• Should have 2+ years of experience using JUnit on projects
• Consistent incorporation of best practices and standards while coding; in particular: secure coding practices
• Good Exposure to building secure and scalable applications
• At least 4+ years handling customers directly should have presented architecture artifacts and technical solutions to customers and influenced customers
• Excellent communication (verbal and written) and interpersonal skills – should be able to influence customer stakeholders and senior management
• Team player and ability to work proactively, provide mentorship and directions to the team and making technical decisions independently

• BE/MCA or equivalent area
• 15-20 years of software industry experience

Must have:

• Knowledge on design, development and deployment of applications based on CMS and Dot Net technology framework
• Strong Analytical, Logical Reasoning and Problem-Solving skills
• Strong in SDLC concepts, RDBMS concepts and SQL/PL-SQL, Data Structures
• Ability to effectively work with a highly technical and virtually located team

Good to have:

• Considerable knowledge in the following: Drupal, .NET MVC, PHP, CSS, Angular, jQuery, Microsoft SQL Server, MySQL, DevOps, Agile software development 
• Exposure to mobile application development using any one of the mobile development platforms (iOS, Android, Windows)

Soft skills:

• Ability to co-ordinate among various user groups and internally within the team. This is a critical skill
• Excellent communication skills, both written and oral
• Ability to multi-task and prioritize
• Deliver on commitments
• Self-Starter and willing to learn many new skills on the job
• Willing to work flexible hours as the job demands
• Excellent trouble shooting skills
• Ability to think through various business issues and come up with solid design solutions that will stand the test of time
• Good listening and influencing skills; a strong customer focus is a must

1. Experience of design and/or development experience with .NET, C#, ASP.NET MVC, APIs, AngularJs and/or Angular, Windows Forms and SQL Server in an n-tier architecture.
2. Strong background in object-oriented development techniques
3. Solution Design Patterns and Best Practices, eg. SOA
4. Database design and development (Microsoft SQL Server)
5. Experience with APIs, Web Services, WCF and Service Oriented Architecture a plus
6. Experience with concurrent development source control (Git) and continuous integration.
7. Understanding of Software Development Life Cycle and Agile methodologies.

• Experience into Manual Testing and Automation Testing- Thorough knowledge on Testing Processes, defect metrics, Automation tools like selenium, QTP- Knowledge on Junit, remedy-
• Thorough quality improvement skills, advanced problem solving and analysis skills- Knowledge of various operating systems - Linux, Windows-
• Knowledge of Agile process-
• Excellent verbal and written communication skills with the ability to work effectively on a team and collaboratively across lines of business-
• Work into QA module for multiple products.