Position responsibilities
Serve as the technical owner, database administrator, and Technical Subject Matter Expert (Technical SME) for the firm's enterprise database platforms, data services, and database-dependent business applications across on-premises, cloud, and hybrid environments
Administer and support Microsoft SQL Server, Azure SQL Database, Elite/3E application servers, SQL Server Reporting Services (SSRS), Power BI, Qlik, Contract Express, Cooley GO, financial systems, and other business-critical database and reporting platforms
Manage all aspects of database administration, including installation, configuration, security, performance tuning, capacity planning, high availability, backup and recovery, patching, upgrades, migrations, and ongoing platform optimization
Serve as the firm's technical expert for database architecture, SQL Server technologies, cloud database services, data integration, reporting platforms, and application interoperability
Design, implement, and support database integrations, application connectivity, data synchronization, reporting services, and AWS data transfer solutions with Qlik and other enterprise platforms.
Partner with business stakeholders, developers, infrastructure teams, vendors, and application owners to deliver secure, scalable, and reliable database and application solutions
Serve as the Tier 3 escalation point for complex database, reporting, application, performance, availability, and integration-related issues, providing advanced troubleshooting and root cause analysis
Lead database and application implementations, upgrades, migrations, modernization initiatives, decommissioning projects, and production releases, including planning, testing, deployment, and post-implementation support
Coordinate vendor support, maintenance activities, support escalations, platform enhancements, and lifecycle management while ensuring database environments meet security, compliance, availability, and business continuity requirements
Develop and maintain technical documentation, operational procedures, runbooks, standards, and disaster recovery plans; evaluate emerging technologies and recommend improvements that enhance platform reliability, efficiency, and long-term strategy
All other duties as assigned or required
Skills and experience
Required
After orientation at Cooley LLP, exhibit proficiency in the Microsoft Office suite, iManage and other firm applications
Ability to work extended and/or weekend hours, as required
5+ years of hands-on experience administering Microsoft SQL Server and supporting database-driven enterprise applications in on-premises, cloud, and hybrid environments
Experience administering Microsoft SQL Server, Azure SQL Database, Windows Server, IIS, and related database technologies
Experience designing, implementing, and supporting highly available database environments, including storage, networking, backup and recovery, disaster recovery, and business continuity solutions
Strong knowledge of SQL Server architecture, database design, data modeling, relational database concepts, and logical and physical database schema design
Proficiency in T-SQL, stored procedures, database security, access controls, backup and recovery methodologies, and SQL Server high-availability technologies, including Always On Availability Groups (AOAG)
Experience with database performance monitoring, troubleshooting, capacity planning, optimization, and performance tuning
Experience implementing and supporting database integrations, ETL processes, data synchronization, application connectivity, and data movement across enterprise platforms.
Experience administering and supporting reporting and analytics platforms, including SQL Server Reporting Services (SSRS), Power BI, Qlik, or similar technologies
Ability to participate in after-hours maintenance, production support activities, and critical incident response as required
Preferred
Bachelor's degree in Computer Science, Information Systems, Engineering, or a related technical discipline, or equivalent combination of education and experience
Microsoft SQL Server, Azure Database, Azure, or related technical certifications
Experience supporting Azure cloud services, Azure SQL Database, hybrid database environments, and cloud-based data integrations
Experience supporting enterprise applications such as Elite/3E, Contract Express, iManage, Inprotech, litigation support systems, eDiscovery platforms, financial systems, legal technology platforms, or other database-driven business applications
Experience with database monitoring and administration tools such as SQL Sentry, SolarWinds, Redgate, or similar technologies
Experience leading database upgrades, migrations, modernization initiatives, server decommissioning projects, and platform lifecycle management activities
Prior law firm, professional services, or other highly regulated enterprise environments, with strong technical documentation and operational runbook development experience
Competencies
Strong analytical, troubleshooting, and problem-solving skills with the ability to identify root causes and deliver effective solutions
Customer-focused with a commitment to delivering high-quality service and building trusted relationships
Excellent verbal and written communication skills, with the ability to communicate effectively with technical and non-technical audiences
Strong collaboration and interpersonal skills with the ability to work effectively across teams, departments, and vendor organizations
Demonstrate accountability, ownership, sound judgment, and a results-oriented approach to work.
Highly organized with the ability to manage multiple priorities, meet deadlines, and adapt to changing business needs
Self-motivated and able to work independently while contributing positively to team success
Demonstrates professionalism, integrity, reliability, and a commitment to continuous learning and improvement
Cooley offers competitive compensation and is committed to fair and equitable employment practices. EOE.
The expected hourly pay range for this position, based on a work schedule of 40 hours per week, is $71.00 - $87.00 per hour ($147,680.00 - $180,960.00 annually). Please note that the final offer amount will be dependent on geographic location, applicable experience and the candidate’s skill set.