Skip to Main Content
← Back to Jobs

Senior Information Technology Analyst

The State Bar of California San Francisco, CA
  • Posted: 10 days ago
  • Full-Time

Questions about the employment opportunities posted here may be emailed to hrla@calbar.ca.gov, or hrsf@calbar.ca.gov. Employees of The State Bar of California receive a range of competitive benefits.

Annual Salary Range: $85,512 - $114,012

Job Summary

The Sr. Information Technology Analystwill be responsible for day-to-day administration of on-prem and hosted SQL server and database environments. As a Sr. Database Administrator, you will be responsible for developing and maintaining our database infrastructure and applications to support the growth of the business and to promote a highly available and stable SQL environment. In this mission critical role, leveraging your senior level technical skills, this position will contribute to the overall design, build and high-level support of all existing and new Microsoft SQL Server systems.

Preferred Technical Experience

  • Design, administer, and manage Azure environments and topologies (e.g., SQL PaaS, IaaS)
  • Migrate and deploy various enterprise on-prem workloads to Azure
  • Manage hybrid Azure AD environments
  • Azure security and monitoring solutions implementation, including automated responses
  • Setup and maintenance of Microsoft 365 user accounts and subscriptions
  • Support of users accessing Microsoft 365 services
  • Serve as the backup for the Windows Systems Administrator
  • PowerShell scripting experience
  • Management and administration of Microsoft Active Directory (e.g., group policy)
  • Knowledge of sound business practices and a proven track record of anticipating and exceeding customer expectations
  • MCTS, MCITP, MCSA SQL 2016, and/or MVP certifications a plus
  • Microsoft 365 Fundamentals Certification and/or Microsoft 365 Certified: Security Administrator Associate

Minimum QualificationsEducation:

Equivalent to the completion of a Bachelors degree from an accredited college or university with majorcoursework in computer science, information technology or a closely related field. Possession of one or more approved information technology certificates and/or completion of other approved technology related training may substitute for some or all of the required education.

Minimum Expereince

  • Four years of experience with Database Administration and hands on development for MSSQL Server as well as with SSIS, SSRS.
  • Administer and manage SQL servers across the enterprise including but not limited to design, implementation, capacity planning, and maintenance in databases in development, QA, and production environments
  • Provide database metrics that summarize the overall application performance and system health of production SQL databases
  • Troubleshoot SQL issues, document solutions, communicate with business and technical resources and work toward sustainable solutions
  • Analyze system performance, identify problems, provide suggestions for database and process improvements, and implement solutions included but limited to performing database tuning, monitoring and health checks
  • Reviews and performs database maintenance, e.g., constrains/indexing, job/process schedules, incident/event and change management, security processes, statistics collection
  • In-depth experience with installation, replication, high-availability (HA) and disaster recovery (DR), log-shipping, database mirroring, Always-On availability groups, cluster options, and operations for Microsoft SQL server 2008 2016
  • Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
  • Proficiency with SQL Management Studio, SQL Profiler and Performance Monitoring to generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them
  • Experience writing and modifying T-SQL scripts and queries as well as SQL Stored Procedures; Assist developers with development of complex SQL query tuning coding standards and schema refinement
  • Proficiency with Analysis Services, Integration Services, and Reporting Services
  • Maintain data integrity and security (manage roles and permissions of database users)
  • Provide 24x7 support for production systems and perform scheduled maintenance and support release deployment activities after hours
  • Install and configure relevant components to ensure secure database access as well as database consistency and integrity.
  • Respond to and resolve database access and performance issues.
  • Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
  • Monitor, optimize and allocate physical data storage for database systems.
  • Plan and coordinate data migrations between systems.
  • Develop, implement, and maintain change control and testing processes for modifications to databases.
  • Create, or support creation of, required reports in response to business user needs.
  • Perform database transaction and security audits.

The State Bar of California

The State Bar of California’s mission is to protect the public and includes the primary functions of licensing, regulation and discipline of attorneys; the advancement of the ethical and competent practice of law; and support of efforts for greater access to, and inclusion in, the legal system. The State Bar: •Licenses attorneys and regulates the profession and practice of law in California •Enforces Rules of Professional Conduct for attorneys •Disciplines attorneys who violate rules and laws •Administers the California Bar Exam •Advances access to justice •Promotes diversity and inclusion in the legal system Created by the Legislature in 1927, the State Bar is an arm of the California Supreme Court, protecting the public by licensing and regulating attorneys. The State Bar licenses more than 250,000 attorneys, investigates approximately 16,000 complaints of attorney misconduct annually and distributes over $30 million in grants to legal aid organizations. We serve the people of California through careful oversight of the legal profession.

What email should the hiring manager reach you at?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.

What email should we contact you at once we get salary info from the hiring manager?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.

Our qualification feature is only available to registered members - what email address would you like for us to keep on file?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.