Database Administrator
1 month ago
Our Program Management Team in Los Angeles has an opportunity for a talented Database Administrator. Explore this opportunity with Psomas and apply today
About being our Database Administrator
As our Database Administrator, you'll maintain the integrity, performance, and security of our client's database systems. You'll design and maintain robust, scalable databases for our cloud-based solutions, optimizing and troubleshooting as needed. Working closely with a skilled project team, you'll leverage the latest technologies to solve complex problems and drive innovation.
Responsibility Highlights for our Database Administrator
- Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
- Implement database solutions that incorporate business logic, data validation, exception handling, and automated reporting.
- Follow necessary quality assurance methodologies to ensure that the database code meets the expected performance and scalability requirements
- Perform performance tuning and query optimization using tools such as Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools.
- Apply good testing methodologies to ensure the reliability and integrity of database systems.
- Work with software version control systems such as TFS, CVS, or Subversion.
- Troubleshoot client issues related to system architecture and review and vet software products and/or applications.
Minimum Qualifications to be our Database Administrator
- 5 years production DBA experience
- 5 years database development experience utilizing TSQL for creating database objects i.e. Tables, Stored Procedures, Functions, Triggers and Views
- 5 years experience in database optimization and query optimization techniques including ability to read query execution plans
- Knowledge and experience with the following: Azure, ETL, ERD, Partitioning, Data Modeling, SQL Manage Instance, Always On to manage failover
- Knowledgable with Microsoft SQL Server and ability to write SQL Queries and Stored Procedures
Preferred Qualifications for our Database Administrator
- Experience with CLR (C#)
- Certified Microsoft Azure Database Administrator
- Microsoft Azure Service Bus and SQL MI Concepts
- Custom web applications (these are City of LA developed)
- Enterprise web applications
- Cloud computing concepts in addition to on-premise solutions
- Software integration solutions with other business systems including data warehousing, BI, CRM, ERP, and analytics platforms
Highlighted Benefits for our Database Administrator
Enjoy hybrid and flexible work schedules, an inclusive benefit package providing medical, dental, and vision coverage for employee and qualifying family members, a 401(k) with immediate vested company match and an Employee Stock Ownership Plan that is 100% paid by Psomas
- A competitive salary The expected range for this position is $100K - $200K/salary depending on experience
- 8 Paid Holidays & 3 Weeks of PTO
- Employee Parking paid by Company
Strong History + Bright Future
As a 100% employee-owned company serving clients throughout the western U.S for over 78 years, Psomas is proud to be an award-winning consulting firm with over 750 employees. Our talented team have an array of skills ranging from construction management, civil engineering, transportation planning, environmental, landscape architecture and urban design, and surveying and geospatial services. We strive for excellence, and welcome candidates of all identities, backgrounds, and perspectives to help us continue evolving as an inclusive, employee first culture. Together, we foster a collaborative work environment, promote teamwork, and provide many opportunities for professional growth and advancement. We are looking for team members that are excited to contribute to our projects and make a positive difference in our local community.
We're a fun, rewarding place to work We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation, gender identity, or any other characteristic protected by law.
Job Posted by ApplicantPro
-
Senior Database Administrator
3 weeks ago
Los Angeles, California, United States Hinshaw & Culbertson LLP Full timeSenior Database AdministratorLocation: Flexible and in any state where the firm has an office.Hinshaw & Culbertson LLP, a national law firm, is currently seeking a Senior Database Administrator to join their team. This full-time position offers competitive compensation and an excellent benefits package.Position Summary:A Senior Database Administrator is...
-
Senior Database Administrator
2 weeks ago
Los Angeles, United States Psomas Full time $100,000 - $200,000Job DescriptionJob DescriptionOur Program Management Team in Los Angeles has an opportunity for a talented Senior Database Administrator. Explore this opportunity with Psomas and apply today!About being our Senior Database Administrator As our Senior Database Administrator, you'll maintain the integrity, performance, and security of our client's...
-
Database Developer
2 months ago
Los Angeles, United States Klompstra Construction Ltd Full timeKlompstra Construction Limited is a long standing servicing construction company .We are searching for database developer to enhance our operations.By joining our experience team with your vast experience and concepts to aid productivity.Candidate must be fluent in all database management protocols and must be ready to work with team members.Role...
-
Database Developer
2 months ago
Los Angeles, United States Klompstra Construction Ltd Full timeKlompstra Construction Limited is a long standing servicing construction company .We are searching for database developer to enhance our operations.By joining our experience team with your vast experience and concepts to aid productivity.Candidate must be fluent in all database management protocols and must be ready to work with team members.Role...
-
Informatica Administrator
3 days ago
Los Angeles, California, United States eTek IT Services, Inc. Full timeJob DescriptionOverview:The role of an Informatica Administrator at eTek IT Services, Inc. is crucial to the organization as it involves managing and maintaining the Informatica platform, ensuring seamless data integration, and contributing to the efficient functioning of the data management infrastructure.Key Responsibilities:Administer and maintain the...
-
Informatica Administrator
3 days ago
Los Angeles, California, United States eTek IT Services, Inc. Full timeJob DescriptionOverview:The role of an Informatica Administrator at eTek IT Services, Inc. is crucial to the organization as it involves managing and maintaining the Informatica platform, ensuring seamless data integration, and contributing to the efficient functioning of the data management infrastructure.Key Responsibilities:Administer and maintain the...
-
Administrative & Customer Support Specialist
3 days ago
Los Angeles, United States Aquent Full timeOur client is a multi-licensed import/export business that manages animal transportation in a bonded warehouse facility near LAX. They are seeking a part-time Administrative Assistant to support their day-to-day operations. You will work closely with their operations team to ensure smooth processes for the import/export of animals. The role involves...
-
Administrative & Customer Support Specialist
2 days ago
Los Angeles, United States Aquent Full timeOur client is a multi-licensed import/export business that manages animal transportation in a bonded warehouse facility near LAX. They are seeking a part-time Administrative Assistant to support their day-to-day operations. You will work closely with their operations team to ensure smooth processes for the import/export of animals. The role involves...
-
Financial Administrative Specialist
2 days ago
Los Angeles, California, United States J M Keehn Accountancy Corporation Full timePosition OverviewThe Financial Administrative Specialist plays a crucial role in supporting our accounting operations. This position involves a variety of tasks aimed at ensuring the smooth functioning of our financial processes.Key ResponsibilitiesDatabase Management: Regularly update, maintain, and organize client databases to ensure accuracy and...
-
Administrative Assistant
1 month ago
Los Angeles, United States S.J. Amoroso Construction Full timeJob DescriptionJob DescriptionSalary: $20-$25 per hourAmoroso Construction is seeking an Administrative Assistant to support the on-site administrative needs. Under the direction of the jobsite Project Manager, the Administrative Assistant will assist jobsite employees with their day-to-day administrative needs.Essential Job FunctionsManage daily...
-
Los Angeles, United States Aquent Full timeOur client is a multi-licensed import/export business that manages animal transportation in a bonded warehouse facility near LAX. They are seeking a part-time Administrative Assistant to support their day-to-day operations. You will work closely with their operations team to ensure smooth processes for the import/export of animals. The role involves...
-
Project Administrator
2 months ago
Los Angeles, United States JM Eagle Full timeJob DescriptionJob DescriptionThe Project Administrator will perform clerical duties on projects, such as tracking and reporting project progress and expenses, as well as coordinate activities related to manufacturing equipment lease and purchase. Work as liaison among project engineers, plant personnel, and equipment suppliers, to track and maintain data,...
-
Clinical Research Associate I
3 months ago
Los Angeles, United States Cedars-Sinai Full timeJob DescriptionAre you a passionate and dedicated research professional?The Material and Information Resources for Inflammatory and Digestive Diseases (MIRIAD) Biobank is the central hub of a full-circle approach to the study of inflammatory bowel disease (IBD). MIRIAD acquires, processes, stores, evaluates and distributes human specimens, which are...
-
Clinical Research Associate I
4 weeks ago
Los Angeles, United States Cedars-Sinai Full timeJob Description Are you a passionate and dedicated research professional?The Material and Information Resources for Inflammatory and Digestive Diseases (MIRIAD) Biobank is the central hub of a full-circle approach to the study of inflammatory bowel disease (IBD). MIRIAD acquires, processes, stores, evaluates and distributes human specimens, which are...
-
Clinical Research Associate I
4 weeks ago
Los Angeles, United States CEDARS-SINAI Full timeJob Description Are you a passionate and dedicated research professional? The Material and Information Resources for Inflammatory and Digestive Diseases (MIRIAD) Biobank is the central hub of a full-circle approach to the study of inflammatory bowel disease (IBD). MIRIAD acquires, processes, stores, evaluates and distributes human specimens, which are...
-
Administrative Support Specialist
1 week ago
Los Angeles, California, United States Pacific Coast Regional Corp Full timeTitle: Administrative Support Specialist EOE Statement: We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law.About the Organization:The primary...
-
System Administrator/Junior DBA
2 weeks ago
Los Angeles, United States Diamond Game Full time $85,000 - $105,000Job DescriptionJob DescriptionWHY DIAMOND GAME?When you work at Diamond Game you are part of a diverse, forward thinking, technology focused gaming organization. Diamond Game employees work alongside one another as part of an engaged team, making contributions at all levels to ensure the highest quality and standards.As a Diamond Game employee, you are...
-
System Administrator/Junior DBA
2 weeks ago
Los Angeles, United States Diamond Game Full time $85,000 - $105,000Job DescriptionJob DescriptionWHY DIAMOND GAME?When you work at Diamond Game you are part of a diverse, forward thinking, technology focused gaming organization. Diamond Game employees work alongside one another as part of an engaged team, making contributions at all levels to ensure the highest quality and standards.As a Diamond Game employee, you are...
-
Administrative Assistant
3 weeks ago
Los Angeles, United States Insight Global Full timeThe Administrative Assistant will provide comprehensive administrative support to the Marketing Department. This role involves managing daily office tasks, coordinating marketing activities, and assisting with various projects to ensure the smooth operation of the department. Essential functions and responsibilities: Administrative Support: Manage calendars,...
-
Administrative Assistant
3 weeks ago
Los Angeles, United States Insight Global Full timeThe Administrative Assistant will provide comprehensive administrative support to the Marketing Department. This role involves managing daily office tasks, coordinating marketing activities, and assisting with various projects to ensure the smooth operation of the department. Essential functions and responsibilities: Administrative Support: Manage calendars,...
