Basics: Our client is seeking a talented Database Analyst who has a history working with SQL.
Location: Tempe, AZ
Rate: $90k+, DOE
•Develops methodology for the ongoing assessment of database performance.
•Identifies and resolves conflicts arising over the creation, control and use of data.
•Works collaboratively with users and team members to gather requirements.
•Develops project specifications, scope and estimated effort.
•Develops database design, table structure and writes store procedures to meet user objectives/outcomes.
•Identifies and troubleshoots errors and/or problems with applications.
•Establishes and monitors security guidelines. Works closely and collaboratively with Web Development teams to identify relevant data sources, develop and/or modify database structures as appropriate Monitors database performance, identifies potential areas for improvement, makes modifications as appropriate
•Works collaboratively with Server team as needed Participate as either leader or team member in a wide variety of projects to develop and improve routine procedures through use of innovative and technology supported solutions
•Prepares associated documentation and end-user training Remains abreast of technology directions, initiatives and trends within scope of expertise to provide ideas, guidance and recommendations.
•Ensures availability and performance of Microsoft SQL Server and other DBMS environments that support multiple critical applications.
•Ensure associated hardware resources are optimally allocated to database servers.
•Proactively monitor the database environments to ensure secure services with minimum downtime.
•Provide trend analysis and database documentation / reports to management team to enable them to make informed decisions regarding resource management and availability of the systems.
•Troubleshoot and problem solve issues related to the Microsoft SQL Server and other DBMS environments.
•Responsible for improvement and maintenance of the databases to include patching and upgrades.
•Implementation and release of database changes to support the application development teams in both the development and production environments.
•Migration of database components from/to DEV, QA, and Production in support of Development teams.
•Review vendor database requirements & recommendations, and implement optimal and secure solutions.
•Microsoft SQL Server Integration Services - Extract, Transform, Load
•This is a 24/7 support environment and will require on-call availability.
Bachelor’s degree in Information Technology or closely related field AND four (4) years database administration including creating and updating table structures and views, writing stored procedures, OR,
ny equivalent combination of experience and/or education from which comparable knowledge, skills and abilities have been achieved.
•Strong knowledge of web based applications and associated database requirements; proactively identifies, develops and deploys solutions to improve effectiveness of technology delivered materials/information.
•Strong understanding of database design principles, practices and methods; security/permission standards; Database query tools including, but not limited to, SQL. Languages including, but not limited to, C#, Python.XML, HTML, and Microsoft Word. Access to SQL queries. Cloud environments such as AWS database Services would be a plus.
•Evidence of experience writing Microsoft SSIS packages, ETL work, performance tuning and SQL tuning.
?Ability to model empathy, compassion and emotional intelligence
?Experience hiring in a values-led organization, emphasizing diversity, equity, inclusion and belonging
?Ability to help foster a safe psychological space for all teammates where everyone can thrive
?Ability to stimulate changes in individual, institutional, and corporate behaviors to create a more sustainable environment
?Ability to lead by example in communicating, participating and encouraging support of the institution’s sustainability programs
Demonstrated understanding of:
•Database design principles
•Practices and methods
•Database Encryption techniques
•Database query tools including, but not limited to, SQL Server Management Studio
•SQL tuning; database indexing
•Database disaster recovery techniques
•Experience in/with the following: design, setup, installation, and implementation of databases in large scale environments; routine database maintenance including backups, restores, re-indexing, integrity checks, jobs, alerts, processes, etc.
•Experience with SQL coding and SQL tuning for optimum performance of queries.
•Self-sufficiency and initiative working on database-related projects
•Ability to implement and document database processes such as component migration, failover, and disaster recovery models
•Effective communication skills.
The Database Administration team is responsible for MSSQL, Oracle, MySQL, Sybase, and PostgreSQL platforms in addition to Cloud environments such as AWS database Services. Any additional experience with these other platforms is a plus.