Senior Database Engineer

• 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 person s 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:

• 8+ 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.