Sql Developer

Role & responsibilities

TECHNOLOGY STACK:

Detailed

The role would be to support one or more databases of low to medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of the data. Developing and maintaining enterprise data documentation and metadata models along with coding, editing, and installing stored procedures and functions for accessing, maintaining, and populating databases. The Database Engineer will be involved in coding, editing, and installing stored procedures and functions for accessing, maintaining, and populating databases. Implementation of database backup and recovery procedures also maintaining development, production, and multiple testing environments. Understanding the process of resolving a query or incidents. Assisting in configuring and monitoring the back-up processes on all the servers and determining the appropriate course of actions for fixing problems, identifies and mitigates risks, and implements solutions. Troubleshooting databases accessibility, availability or operability problems and conducting Level 2 support. Communicate important information regarding incidents and service requests to concerned stakeholders.

Competencies:

• Understands and meets stated needs & requirements of the stakeholders and work output to truly partner with all concerned stakeholders.
• Takes responsibility for development of self and team; creates long-term development plans and monitors their progress.
• Proactively seeks and supports new ideas and options generated by others.
• Modifies and adapts current methods and approaches to better meet needs.
• Adapts to diverse cultures and ideas to ensure success of projects.
• Acts and responds quickly to stated business, people or stakeholder challenges.
• Identifies problems and draws conclusions by gathering, analyzing, and interpreting quantitative and qualitative information.
• Chooses the best course of action by establishing decision criteria and evaluating alternatives.
• Proactively shares concern for meeting defined goals related to time, quality and budget and takes corrective measures.
• Demonstrates an astute understanding of the other persons views by asking the right questions at the right time.
• Has ability to take technical decisions on critical design aspects
• Excellent problem solving, collaboration, and communication skills.

Technical Skills:

• 6+ years in Structured Query Language (SQL), e.g. SQL/PSM, Transact-SQL queries, writes SQL scripts in SQL Server 2000/2005/ 2012/ 2016, etc.
• 2+ years in Cloud Database services like AWS Dynamo DB / RDS
• Excellent Troubleshooting skills of existing functional implementation to derive leaner solutions and effective performance between applications software, systems software, and installed hardware.
• Install troubleshoot and resolve the SQL Servers/SSRS/SSIS/SSAS and related software to ensure a working interface and effective performance between applications software, systems software, and installed hardware.
• Database instance maintenance tasks such as DB Integrity Checks, Index Maintenance, backups, recovery, Capacity planning and performance monitoring.
• High availability like clustering, log shipping, mirroring, replication.
• Backup and disaster recovery, Capacity planning and performance monitoring, Physical database structure, RDMS administration roles, instances, profiles, and security connectivity.
• Developing, implementing, maintaining, and following change control and testing processes for modifications to databases.
• Establishing backup and recovery or replication plans to minimize data loss and system downtime.
• Improving data quality through data analysis, monitoring, gap analyses, and working with the teams to provide solutions and resolve errors.
• Maintaining data integrity and security (manage roles and permissions of database users).
• Reviewing the security logs from the SQL Server Error Logs to determine if you had a breach or a violation in one of your policies.
• Ensures optimal database performance and availability.
• Creation & maintenance of Databases in AWS.
• Hands-on experience with big data application development and/or with cloud data warehousing (e.g., Spark, Redshift, Snowflake, Azure SQL DW, BigQuery) is a big plus.