The Senior Database Administrator will be assigned to work with one or more development project teams. In this role they will be expected to:
- The System Engineer will be responsible for building, supporting and managing end-to-end solutions within Amazon AWS and Azure Cloud environments.
- Support SCRUM teams in an Agile development environment.
- Working with the Solutions Designer, Development Architect and third parties as appropriate, the engineer will be responsible for ensuring that a technical design document describing the technical architecture for the program/project is produced.
- Understand the business and application requirements and translate into a database design.
- Ensure that all technology selected for the program conforms to the organizations technical long-term strategy.
- Be responsible for the availability, stability, recoverability and performance of the database environment by ensuring all systems are monitored, patched, and operating optimally.
- Design and develop complex SQL queries and appropriate database code such as stored procedures, triggers, functions to support complex business processes.
- Develop and deliver extensible/sustainable/quality database solutions based on defined business needs.
- Review and update stored procedures for optimal performance. Identify and correct performance bottlenecks related to SQL code.
- Recommend changes to the relational data model to solve performance issues with SQL code. Requires a solid understanding of relational database design and concepts.
- Monitor and troubleshoot SQL jobs using available tools such as SQL Profiler, Quest Spotlight, review logs and triage issues.
- Participate in the resolution of production data issues.
- Perform code reviews, providing feedback in a timely manner. Incorporate feedback from code reviews as appropriate.
- Participate in the review of all database schema projects; provide feedback and identify impacts to existing environment.
- Monitor business data stored in production databases, ensuring integrity of the data is maintained.
- Responsible for developing, maintaining and deploying SSIS packages.
- Participate in release of all stored procedure projects; including release documentation.
- Maintain knowledge as new versions of SQL Server are released and leverage new functionality as appropriate.
- Proactively identify and act on opportunities to improve database systems and processes.
- Contribute to standards documentation for database coding practices.
- Prioritize multiple tasks so that aggressive deadlines are met.
- Provide ongoing suggestions for improvement and innovation within the department.
- Exhibit sound, methodical engineering judgment, and effectively manage trade-offs in a business environment.
- Familiar with one or more of the below or other programming languages : VBScript, JavaScript, VB, Java, .NET,PERL
- Maintain and exhibit knowledge of AWS RDS, Azure SQL and NOSQL database
- Provide after-hours support as required to address system outages and perform system updates/upgrades/modifications.
- Identify new processes or modify existing processes to improve efficiencies in the support and monitoring of the department’s production applications.
- Perform other duties as required.
REQUIREMENTS:
- B.S. Degree in Information Technology, Computer Science or a related discipline is preferred.
- MCSE/Azure Certification preferred.
- 5-8 years of experience in database development and support in MS SQL Server environment.
- 3+ years working experience in deploying physical and cloud instances of SQL Server. (Azure preferred)
- 2+ year of working with PostgreSQL.
- Working Knowledge of Databricks administration and Datalake, is a plus. (Azure Preferred)
- Working knowledge noSQL database technology. (Mongo, Cosmos, Others)
- 3+ years of experience in scripting language like Powershell, VB Script, Python, or similar.
- Strong understanding of Security guidelines in Cloud environment.
- Open to work on Infrastructure projects and assist on Environment buildouts from Database and Data Analytics perspective.
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking & deadlocking issues, replication/log shipping issues, network/connectivity issues, security issues, etc.
- Experience in Performance Tuning, Query Optimization using SQL Monitor, New Relic, and other related tools
- Ability to detect and troubleshoot SQL Server related hardware resource contention such as CPU, memory, disk IO, etc.
- Solid acquaintance with windows server, security models, and storage components such as SAN.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
- Advanced experience with TSQL language and stored procedures, transactional replication, multi node clustering, mirroring, etc.
- Knowledge of Data Warehousing and Column store databases.
- A broad understanding of enterprise-class technologies
- Extensive knowledge and experience with large scale client facing online systems
- Extensive knowledge and experience with Amazon AWS technologies
- Extensive knowledge and experience with Windows based technologies
- Ability to communicate and to interact effectively with co-workers and customers is required.
- Ability to work and adapt in a dynamic environment and recognize priority issues, escalating accordingly
- Experience with creating standards and documentation
- Ability to work both independently or as part of a project group, with time constraints
- Strong customer service oriented; organizational and communication skills, positive and can-do attitude
- A technical troubleshooting and prioritization skills test will be part of the interview process.