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
Sr. PHP Developer
Position: Senior Laravel Developer
Key Responsibilities:
· Develop and create websites, applications, and systems
· Participate on the Development and Testing Phase of the Projects
· Participate as a member of the Scrum team
· Maintain and enhance existing Projects
· Deliver quality output on all Projects
· Showcase your analytical and problem-solving ability.
· Guide and Mentor other developers
· Be updated on the latest technologies
Requirements:
· More than 4-8 years’ experience in PHP
· Must have minimum 4 years work experience in Laravel framework
· Knowledge and experience in: MySQL, JQuery, Bootstrap, HTML,CSS
· Knowledge on Coding Standards, Design Patterns, and Best Practices
· Has experience and understanding on Agile Software Development.
· Ability to prioritize and handle multiple tasks and projects concurrently.
· Able to mentor, collaborate and guide other team members
· Team Player, Proactive and Accountable
• Involved in code development and implementing database changes and design pattern.
• Good code reviews and code debugging skills.
• Design, Development, Programming, Maintaining and customizing solutions to meet customer’s specific needs.
• Product Development is added advantage.
Roles and Responsibilities
Experience in full cycle implementation of software development projects using .NET 4.0 and above, C#, ADO.NET, ASP.NET, MVC / .Net Core
Experience in developing of Web API and RESTful web services. Experienced with client-side programming HTML, CSS, AJAX.
Experience with Entity frameworks and Dappers Programming skills on SQL Server with strong database design.
Desired Candidate Profile
1+ years of software development experience .Net Development, C#, ASP.Net MVC
Dot Net core expertise is a must
Strong working knowledge of SQL Server, C#, JavaScript and JQuery
Strong working knowledge of .NET MVC LATEST VERSION
Strong working knowledge of ENTITY FRAMEWORK
Excellent written and verbal interpersonal skills for coordinating across teams
Deep experience and expertise with designing, implementing, testing and deploying sophisticated .Net applications
Keenness to learn and master new technologies and techniques
Excellent software development skills with very sound logic
- Strong experience working as a .Net developer.
- Proficient in Microsoft .NET development using C#. Experience with web development technologies including http://asp.net/">ASP.NET, MVC, EF, HTML, JavaScript, Angular, JQuery, AJAX, and CSS.
- Experience designing and developing enterprise-grade software.
- Experience with source control management systems and deployment environments.
- Experience with debugging, performance profiling and optimization.
- Comprehensive understanding of object-oriented and service-oriented application development techniques and theories.
- Internally motivated, able to work proficiently both independently and in a team environment.
Job description
- Creating the website architecture.
- Designing and managing the website back-end including database and server integration.
- Generating WordPress themes and plugins.
- Conducting website performance tests.
- Troubleshooting content issues.
- Conducting WordPress training with the client.
- Monitoring the performance of the live website.
Requirement:
- Bachelor’s degree in Computer Science or a similar field.
- Proven work experience as a WordPress Developer for min 2 years.
- Strong knowledge on PHP
- Knowledge of front-end technologies including CSS3, JavaScript, HTML5, and jQuery.
- Knowledge of code versioning tools including Git, Mercurial, and SVN.
- Experience working with debugging tools such as Chrome Inspector and Firebug.
- Good understanding of website architecture and aesthetics.
- Good communication skills.
Salary: Negotiable depend on last drawn/current
- 2+ years of experience on Java, Spring Boot, Hibernate in medium to large-scale projects
- Must have experience with at least some flavours of both SQL (MySQL, Postgres) and NoSQL (Kafka, MongoDB, ElasticSearch, NoSQL distributed cache system, DynamoDB etc), datastores in production
- Must have experience with Kafka or similar message queue systems in production
- Stellar problem solving skills
- Hunger to learn new things and ability to grasp new concepts quickly
- Ability to move quickly without breaking things too much (we are dreamers)
- Ability to work under immense pressure which is balanced by a sense of responsibility and ownership
- Should be able to groom juniors and take them to the next level
Job Description:-
- Php Developer Skills Required.
- Good working knowledge on Core PHP.
- Strong knowledge of MVC Framework and knowledge of Laravel.
- Good working knowledge of JavaScript & JS frameworks, preferably jQuery.
- Strong knowledge of MySQL databases & OOPS concepts.
- Strong knowledge of ORM and query builder.
- Knowledge of queue scheduling and task scheduling.
- Strong knowledge of Artisan commands.
- Hands on experience of service providers and create new service providers in the application when needed.
- Integration of user-facing elements developed by front-end developers.
- Build efficient, testable, and reusable modules.
- Solve complex performance problems and architectural challenges.
- Write well designed, testable, efficient code by using best software development practices.
- Integrate data from various back-end services and databases.
- Create and maintain software documentation.
- Knowledge of Rest APIs.
- Knowledge of the payment gateway integration (PayPal, PayUMoney, CC Avenue etc.)
- Good knowledge of wallet integration (Paytm, Phone-Pe, Amazon) etc.
- Proficient understanding of code versioning tools, such as Git is mandatory.
- Ability to debug the code and resolve the issues.
Key Responsibilities:-
- Build reusable code and libraries for future use.
- Participate in the full lifecycle of the projects.
- Optimize application for maximum speed and scalability.
- Ability to work independently and within a team environment.
- Assist in troubleshooting any production issues.
- Working within an existing code base and also writing code from scratch.
- Good team player -collaborate with other team members and stakeholders.
- Commitment to meet corporate goals and tight deadlines.
Key Skills:- HTML, CSS, Bootstrap, jQuery, JavaScript, PHP, Core PHP, knowledge of MVC framework, database, MySQL, Laravel Framework, Rest APIs, 3rd party tool integration, OOPs programing concept.
Experience:- 3+ Years’ experience.
Education Qualification:- B.E./B.Tech. /MCA or equivalent in computer science or a related field.