11+ Transact-SQL Jobs in Pune | Transact-SQL Job openings in Pune

We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.

For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.

Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.

We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.

Working as Senior Microsoft SQL Developer at Navtech, you will:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

Who Are We Looking For Exactly? 

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. Should have excellent logical, analytical, and communication skills with client interaction experience.

Benefits

• Working with industry giants while following your passion for technology.
• Competitive pay package with additional bonus and benefits.
• Performance review and Appraisal Twice a year.
• Family Health Insurance cover for self and family.
• Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
• Work with a culturally diverse team from different geographies

Oracle Functional

 

Job Description

Oracle EBS Techno Function with 4+ years' of experience

Excellent functional knowledge of Financial modules (Specially GL, FA)

Expertise in Oracle EBS Financial, Project, Purchasing module

Able to understand the accounting concepts

Few technical skills like PLSQL, personalization, XML reports

Worked on Oracle EBS 12.2+ implementation and support

Qualifications

Graduate specially with accounts

Additional information

Excellent verbal and written communication skills.

• To support and maintain existing Java code base, debug the application 
• To analyse user and business requirements and design and implement appropriate solutions 
• To design and code programs following in-house standards and good design principles 
• To ensure that all programs are documented to the company standards 
• To create unit test plans and perform unit testing of the programs
• To provide advice and guidance to other members of the team

• Hands on experience in designing and developing applications using Java EE platforms 
• Object Oriented analysis and design using common design patterns 
• Good knowledge of Relational Databases, SQL and ORM technologies (JPA2, Hibernate) 
• Experience in the Spring Framework 
• Experience in developing web applications using at least one popular web framework (JSF, Wicket, GWT, Spring MVC) 
• Experience in RESTFul webservices
• Experience with test-driven development 
• Exposure to portal/mobility development - Desired
• Exposure to any of middleware solutions like MQ, Oracle fusion middleware(WebLogic), WebSphere, Open Source

MS SQL 2012 Server Administrator, with experience of data migration projects using SSRS, SSIS packages. Needs to have a very strong and credible record as a DBA, experience of handling enterprise Data Base migration projects preferably in a financial or banking arena. Provide hands on support to our internal DBA and development teams. Strong knowledge of database design, query cost and performance measurement, use of stored procedures and performance tuning. Experience in using Integration Services (SSIS) platform for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations. Will provide database functions by designing and coding utilities and scripts Maintains database performance by calculating optimum values for database parameters; implementing new releases and completing maintenance requirements. Provides information by answering questions and making recommendations. Maintains quality service by establishing and enforcing organization standards.

Key Responsibilities Technical leader for features you own and work on within Endpoint Work with your feature team to write, test, maintain and deploy high quality software Write clean, elegant, testable code Mentor more junior members of the engineering and QA staff Help drive the adoption of best practices in code quality, health and testability Help to break down and size work for the team You must have: You should be fluent in core computer science concepts, algorithms and patterns 10+ years of experience developing software with relevant experience Windows and/or Mac OSX development Object oriented design and programming Unit Testing Multi-threaded programming Agile methodology and development Expert at Angular 2,4 or 5, C# and SQL Server You are an excellent communicator You take pride in your work You believe in building a great customer experience You believe in ownership and accountability

Mandatory Skills:

• As a polyglot developer Ideally, you should have:
• 1.5+ years of development experience using any of technology java, scala, python or any similar exciting technologies.
• Hands-on experience in coding, and implementation of complex, custom-built applications Working knowledge of build tool like maven/sbt and code versioning systems like git/bitbucket/cvs/svn
• Familiarity with few databases, like MySQL, Oracle, PostgreSQL, SQL Server, NoSQL etc Great OO skills, including strong design patterns knowledge
• Good communication and ability to work in a consulting environment is essential

Good to Have:

• Think through hard problems in a consultancy environment, and work with amazing people to make the solutions a reality Work in a dynamic, collaborative, non-hierarchical environment where your talent is valued over your job title or years of experience
• Build custom software using the latest technologies and tools Craft your own career path

You'll be responsible for:

• Providing solution to real problems in Bigdata world.
• RnD on using the latest tools,techniques and cloud services.
• Automating the manual-timetaking tasks.
• Hands-on coding, usually in a pair programming environment.
• Working in highly collaborative teams and building quality code
• Working in lots of different domains and client environments
• Understanding the business domain deeply

What we do:
We are a team of technology agnostic, passionate people who aim to provide solution to real world Bigdata problems.
We are building solutions that will help our customers to do automatic migration of their RDBMS systems to latest BIGDATA platforms and tools such as Spark, Apex, Flink etc. For more information do visit our products webpage.  

Minimum 4 years of experience in working with C#, JavaScript (NodeJS), .Net Framework, MVC, MEAN Stack, for developing web applications/Web API with Storage like SQL server, MongoDB etc. using ORM like Entity Framework or Custom ORM Working experience in writing high performance and secured Web Services ( WCF, REST Web API) Ability to write a quality and modular code Extensive Web development expertise using Html/Html5, CSS, JavaScript, jQuery, XML,JSON, AJAX along with C#, NodeJS and .Net Framework. Experience in implementing required Design Patterns, good understanding on Solid Principles and Object-oriented application design. Experience in various source control/Agile/Build and release tools like TFS, JIRA, Jenkins etc. Working with Chart controls, Excel Files, Reporting tools is preferable Passionate about building high-quality systems with software implementation best practices while leading and mentoring a team of developers, if assigned to. Analyse, diagnose and resolve errors related to the product/application Capable of defining LOE, project plans based on business requirement Investigate operational or systematic problems and user queries as required Interact and communicate effectively with all levels of staff, senior management and customers Strong debugging skills, communication skills and Dedicated Team player Bachelor degree in related field, or relevant experience

SUMMARY
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.

Java development for a Saas solution (on production for 5+ years). Comfort with AWS, microservices, EJB, Flutter will be advantages. Java and SQL skills are critical.

We are looking for exceptional programming skills. That's it.