Datbase platforms developer
at A marketing technology and services company
The Database Developer will perform day-to-day database management, maintenance and troubleshooting by providing Tier 1 and Tier 2 support for diverse platforms including, but not limited to, MS SQL, Azure SQL, MySQL,
PostgreSQL and Amazon Redshift.
They are responsible for maintaining functional/technical support documentation
and operational documentation as well as reporting on performance metrics associated with job activity and platform
stability.
Must adhere to SLAs pertaining to data movement and provide evidence and supporting documentation for incidents that violate those SLAs.
Other responsibilities include API development and integrations via Azure
Functions, C# or Python.
Essential Duties and Responsibilities
• Advanced problem-solving skills
• Excellent communication skills
• Advanced T-SQL scripting skills
• Query optimization and performance tuning familiarity with traces, execution plans and server
logs
• SSIS package development and support
• PowerShell scripting
• Report visualization via SSRS, Power BI and/or Jupityr Nootbook
• Maintain functional/technical support documentation
• Maintain operational documentation specific to automated jobs and job steps
• Develop, implement and support user defined stored procedures, functions and (indexed) views
• Monitor database activities and provide Tier 1 and Tier 2 production support
• Provide functional and technical support to ensure performance, operation and stability of
database systems
• Manage data ingress and egress
• Track issue and/or project deliverables in Jira
• Assist in RDBMS patching, upgrades and enhancements
• Prepare database reports for managers as needed
• API integrations and development
Background/Experience
• Bachelor or advanced degree in computer science
• Microsoft SQL Server 2016 or higher
• Working knowledge of MySQL, PostgreSQL and/or Amazon Redshift
• C# and/or Python
Supervisory/Budget Responsibility
• No Supervisory Responsibility/No Budget Responsibility
Level of Authority to Make Decisions
The Database Developers expedite issue resolution pursuant to the functional/technical documentation available.
Issue escalation is at their discretion and should result in additional functional/technical documentation for future
reference.
However, individual problem solving, decision making and performance tuning will constitute 75% of their time.
Similar jobs
• PHP / Laravel developer duties and responsibilities
• Develop, record and maintain cutting edge web-based PHP applications on portal plus premium service platforms
• Build innovative, state-of-the-art applications and collaborate with the User Experience (UX) team
• Ensure HTML, CSS, and shared JavaScript is valid and consistent across applications
• Prepare and maintain all applications utilizing standard development tools
• Utilize backend data services and contribute to increase existing data services API
• In depth knowledge of object-oriented PHP and Laravel 5 PHP Framework
• Hands on experience with SQL schema design, SOLID principles, REST API design
• MySQL profiling and query optimization
Involvement in the full software development life cycle within broadly defined parameters and providing software solutions keeping into consideration the software quality needs Design and defining the interaction between the different component pieces Write efficient code based on brief given by team lead. Fast prototyping of proof-of concept features / application based on brief. Develop and maintain new features on Java stack Own the delivery of an entire piece of a system or application Management and execution against project plans and delivery commitments Work closely with the peers and Leads to develop the best technical design and approach for new product development Build software solutions for complex problems. Compliance with build/release and configuration management process Responsibility to develop unit test cases for his/her project module. Execution of appropriate quality plans ,project plans ,test strategies and processes for development activities in concern with business and project management effort
Desired Profile:
Good understanding of Object Oriented Programming Concepts, hands-on knowledge on Java stack (Spring/Hibernate) Development across multiple browsers/platforms on Website Good Understanding of SQL/NoSQL data stores Fair Understanding of Responsive High Level Designs Work experience in product/start-up company is a plus Familiarity to MVC, SOA, RESTFull web services Work with other teams and manage time across multiple projects and tasks in a deadline driven, team environment Good to have knowledge of Javascript (AngularJS/ReactJS)/HTML/CSS/JQuery front-end code across a broad array of Interactive web Understand agile methodology and instill best practices into the proce
- Application Developer -API
- Experience: 2-5 years
- Experience in Design, build and configure applications to meet business process and application requirements using AZURE API development.
- Design, Build, Test and deploy the APIs using Microsoft Azure.
- Needs to support and handle the production APIs.
- Should have knowledge in Design Patterns.
- Job Title:- Team Lead
- :- B. Tech / B. E in (CS/ IT/ Electronics)/ MCA
- Years of Exp.:- 10 years
- Location:- DoIT, Yojana Bhawan, C Scheme, Jaipur
Technical Experience:-
- Manage Design, development and delivery of application and Maintain high standards of software quality within the team by establishing good practices and habits.
- Technical Knowledge in Software Development and server Architecture.
- Experience of QMS and SDLC Processes Successful handling of IT Technology projects in Software systems.
- Interact with the client to create technology specifications from business requirements for modules within the project.
- Project experience in a Web technologies, mobile technologies, enterprise web software and Prior experience of working in PHP (CI, Laravel), Mysql, Jquery, Javascript HTML and Ajax.
Ideal candidate must have :
- 2+ years of experience in writing code
- Ability to meet tight deadlines
- Can work independently and be a team contributor
- Must have good knowledge of Node, Python and Scripting languages
- Experience in one or more of RDBMS - PostgreSQL, MySQL or Oracle
- Experience with NoSQL and real-time DB - Firebase/Firestore or MongoDB
- Must be able to write concise and high-quality API
- Must be a quick learner, curious and ambitious
1. Experience in Laravel (Min 1 yrs current project).
2. Understanding of open source eCommerce platforms like Php, Magento.
3. Experience in REST APIs integrations.
4. Basic understanding of front-end technologies, such as JavaScript, HTML5, and CSS3