SQL server (DBA)(2008,2012,2016) versions

JOB DESCRIPTION AND RESPONSIBILITIES:

• Work as a Member of The File Transfer Engineering team involved with the Configuration, Maintenance, and Support of Sterling File Gateway, Connect Direct (NDM) environment.
• This position will participate in the design & development of technical solutions within company strategic B2B/MFT platform which provide innovative technical improvements, improve quality and operational excellence, lower cost, satisfy regulatory and compliance requirements, mitigate risk, and satisfy business objectives.

QUALIFICATIONS:

• Bachelor’s degree in computer engineering/Science Degree or related field
• 4-5 years’ experience in supporting real time production environments.
• Extensive debugging skills and fixing experience
• General knowledge of industry standards and best practices for supporting middleware technologies
• Knowledge of Ping Access, Ping Federate, LDAP, Active Directory, Connect Direct (NDM) Unix/Windows/Mainframe
• Developing transformation maps and processes for any-to-any data formats and RDBMS queries using IBM Sterling B2B Integrator mapping and business process modeling tools.
• This position requires sophisticated knowledge of B2B/MFT concepts, technologies, best practices, standards, and architectures within the IBM File Gateway suite.
• Minimum five years of technical experience in IBM File Gateway Suite (IBM Sterling B2B Integrator (preferably version 6.x) and IBM Sterling File Gateway, Sterling External Authentication Server, Secure Proxy, IBM Control Center Monitor) including:
• Experience with Installation and configuration of multi-node architecture environments, including upgrades and platform migration.
• Experience in setting up and testing disaster recovery environment to handle failover scenarios.
• Experience with onboarding new partners, transactions and making changes to existing partners to meet internal and external requirements.
• Experience in configuring adapters, service configuration and policies.
• Experience in setting up and configuring industry-standard communication protocols such as SFTP, FTPs, FTP, HTTP, HTTP, Connect: Direct, WebSphere MQ
• Experience with security configurations SSL certificates, SSH keys, PGP/GPG
• Experience with IBM File Gateway Suite maintenance and administration
• Experience with external authentication integration
• Experience with Java extensibility
• Development of custom protocols, custom file layers and custom consumer identification
• Must possess strong analytical, problem-solving, and root cause analysis skills.
• Hands-on experience in Production Support, resolving critical incidents using the IBM File Gateway Suite
• Knowledge of SQL queries, database schemas and related concepts using Oracle
• Knowledge of IBM Sterling File Gateway APIs.
• Should have Excellent communication and customer service skills.

 SQL Server DBA duties and responsibilities

• Experience in  both sql server DBA and DBA developer

•             Configure and maintain database servers and processes

•             Monitor system's health and performance

•             Ensure high levels of performance, availability, sustainability and  security

•             Analyze, solve, and correct issues in real time

•             Provide suggestions for solutions

•             Refine and automate regular processes, track issues, and document changes

•             Assist developers with query tuning and schema refinement

•             Perform scheduled maintenance and support release deployment activities

•             Database programming skills(writing and understanding Procedures , scripts..)

Good to have experience to SSIS,SSAS SSRS or any reporting tools.

Job Description

• Be a champion for technical solutions on the Microsoft platform with a keen understanding of Dynamics NAV/BC development practices, and a good knowledge of other development techniques. Should have done upgrades from previous versions and data migration from various legacy applications.
• Provide capability to develop sector-specific templates to enhance the out of the box Dynamics NAV/BC functionality, giving a unique selling point and also a resaleable asset.
• Work closely with the architecture team to design and develop our most complex customer needs, providing development only where these requirements cannot be met through configuration. Creating high quality and sustainable client solutions and project documentation.
• Meet and exceed customer expectations of business knowledge, skills and behavior. Identify business/project risk and mitigate or communicate as necessary.
• Participate in pre-sales activities as requested.
• Support practice development activities such as defining and configuring industry-specific templates.

Responsibilities:

• Be a champion for technical solutions on the Microsoft platform with a keen understanding of Dynamics NAV/BC development practices, and a good knowledge of other development techniques.
• Work closely with the architecture team to design and develop our most complex customer needs, providing development only where these requirements cannot be met through configuration.
• Provide capability to develop sector-specific templates to enhance the out of the box Dynamics NAV/BC functionality, giving a unique selling point and also a resaleable asset.
• Support practice development activities such as defining and configuring industry-specific templates.
• Participate in Pre-sales activities as and when required.

Technical Skills:

Primary Skills Required(Dynamics NAV/BC)

• Extensive experience with Dynamics NAV/BC up to the latest versions
• Broad Dynamics NAV/BC module understanding covering all core modules and additional add-on solutions
• Direct experience in consultancy and solution architecture within a Microsoft Gold Partner environment
• Track record of Dynamics NAV/BC implementation experience either as a team member or team leader.
• Knowledge of NAV/BC implementation and end to end implementation
• Experience with NAV/BC interfacing and integration. Experience in gathering technical requirement. upgrades and migration knowledge is important
• Beneficial to know Agile and Sure Step methodologies
• Experience in other technologies such as D365, SQL, Power BI, SSAS, SharePoint along with knowledge of Azure and .Net;
• Strong verbal and written communication skills, along with well-developed interpersonal skills and an ability to relate to clients and colleagues

Secondary Skills:

• Knowledge of SQL Server, MS Azure, Power BI, SSRS.(Required)
• Good to have someone with Auto domain expertise. Should have very good experience in client handling

Soft Skills Required:

Strong personal organization and time management skills

• Installing and maintaining the Oracle database software.
• Creating storage database structures with high-level security features.
• Altering storage structures to meet the evolving needs of the company.
• Setting up database user accounts.
• Training users on how to access the information in the database.
• Finding and debugging malfunctioning programs affecting the database integrity.
• Creating autonomous database backups.
• Regularly updating the database security protocols.

10+ years of experience in SQL Server Administration

Should be hands on

Able to handle customer communication and expectation management

Proactively plan and implement the project/support activities

Focus on continuous improvements
Must have experience in managing team of SQL Server DBAs
should have good customer and client management skills
should have good communication skills

• Design, develop, implement and maintain our core Oracle applications.
• Maintain our SQL / PLSQL processes.
• Ensure DB availability.
• Proactively manage and maintain security standards and controls by creating storage database structures with high-level security features.
• Actively seek to optimise and simplify our architecture.
• Take ownership of performance and capacity monitoring aspects of the DB.
• Execution of data migration jobs and scripts as required.
• Assist the infrastructure team in sizing hardware used for the DB.
• Support and collaborate with product developers.
• Contribute to the creation and maintenance of disaster recovery plans.
• Work closely with the application vendors, co-ordinate and manage the DBA activities.
• Own and follow up with Vendors/Stakeholders & their DBAs when required.
• Create a reliable backup strategy. Ensure database backups are appropriately
• executed and periodic restorations are exercised to ensure backup quality.
• Determine and document DB policies, procedures and standards.
• Performance testing and evaluation to ensure data security, privacy and integrity.
• Identification of bottle necks and deadlock issues.
• Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.
• Install upgrades and security patches.
• Alter storage structures to meet the evolving needs of the company.
• Set up database user accounts.
• Train users on how to access the information in the database.
• Find and debug malfunctioning programs affecting the database integrity.
• Create autonomous database backups.
• Regularly update the database security protocols.

Desired Skills:

• Ideally Oracle Certified DB Professional (OCP) with more than 5 years’ experience with Oracle, preferably in a lead role.
• Technical degree preferable (B.E. / B. Tech).
• Must experience with an organisation that has 24x7 reliability on its database.
• Must have experience with Oracle Exadata.
• Must Operating system experience in Linux.
• Must hands on knowledge of Shell scripting on Linux Platform
• Must hands on knowledge of Oracle management tools (Data Guard, RMAN).
• Must hands on knowledge of SQL / PLSQL.
• Experience should include DB design (modelling and normalisation), capacity planning, performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies.
• Knowledge of Partitioning.
• Knowledge of architecture design principles.
• Good problem solver, focused and dedicated developer with ability to work on
• your own as well as with a team.
• Hands on experience with DB standards and end user applications-translating
• capacity requirements into infrastructure deployment technology.
• Strong practical experience of ORACLE in a production environment (Ver 19c).
• Must be a self-starter with a strong attention to detail.

Relevant work experience:

• 5+ years working in the Information Technology Industry
• 2+ years system engineering or platform engineering