Robotics technology LLC
San Antonio, Texas
Ensuring Data Quality: They use Bigeyes data observability features to monitor data quality and identify potential issues.Understanding Data Relationships:They use Alations data catalog to understand the relationships between different data assets.Data Lineage: They use data lineage to identify the impact of changes to data assets.Data Profiling:They use data profiling to determine the usability of data assets.Trust Flags: They use trust flags to signal the trustworthiness of dataData Tagging: Identifying data elements and applying appropriate tags to ensure proper tracking and measurementsData Quality Rule/Plan: Determine and assign appropriate data quality rules, testing, and plans are assigned to ensure veracity of data when engine runs.Must have experience with all USAA internal systems, policies, standards, procedures including IGC, RRAIT, IAI, IA, UDC/Alation, BigEye.Must have experience of playing a lead role in at least 2 to 3 mid-large sized projectsLeads a team of data modelers in large projects for creation logical and physical data models using best practicesOptimizes and updates logical and physical data models to support new and existing projectsMaintains conceptual, logical and physical data models along with corresponding metadataClosely coordinates and liaises with the Business Analysts and Technical Architects on high complexity work to ensure the effective translation of business and technical requirements into the logical data modelDesigns standard naming conventions and coding practices to ensure consistency of data modelsEvaluates data models and physical databases for variances and discrepanciesMust validate data models and physical database for variancesHighly experienced with ETL tools such as Informatica, DataStage, Ab Initio, etc. Equal Opportunity EmployerWe are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.
Ensuring Data Quality: They use Bigeyes data observability features to monitor data quality and identify potential issues.Understanding Data Relationships:They use Alations data catalog to understand the relationships between different data assets.Data Lineage: They use data lineage to identify the impact of changes to data assets.Data Profiling:They use data profiling to determine the usability of data assets.Trust Flags: They use trust flags to signal the trustworthiness of dataData Tagging: Identifying data elements and applying appropriate tags to ensure proper tracking and measurementsData Quality Rule/Plan: Determine and assign appropriate data quality rules, testing, and plans are assigned to ensure veracity of data when engine runs.Must have experience with all USAA internal systems, policies, standards, procedures including IGC, RRAIT, IAI, IA, UDC/Alation, BigEye.Must have experience of playing a lead role in at least 2 to 3 mid-large sized projectsLeads a team of data modelers in large projects for creation logical and physical data models using best practicesOptimizes and updates logical and physical data models to support new and existing projectsMaintains conceptual, logical and physical data models along with corresponding metadataClosely coordinates and liaises with the Business Analysts and Technical Architects on high complexity work to ensure the effective translation of business and technical requirements into the logical data modelDesigns standard naming conventions and coding practices to ensure consistency of data modelsEvaluates data models and physical databases for variances and discrepanciesMust validate data models and physical database for variancesHighly experienced with ETL tools such as Informatica, DataStage, Ab Initio, etc. Equal Opportunity EmployerWe are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.
Best analyticsllc.com
Baltimore, Maryland
Job Description The Senior Database Administrator (DBA) will work within a pool of other Senior DBAs to support approximately 20 online transaction processing (OLTP) applications, online analytical processing (OLAP) applications, and decision support systems (DSS). The database environment consists of databases that range in size from several hundred gigabytes (GB) to several terabytesized databases. The database management systems are both SQL Server and Oracle, so the successful applicant will have experience with both environments. The Senior DBA pool will support these applications in both a localDBA and centralDBA model. As the Local DBA, the candidate will directly provide all database services, including programming, tuning, design, etc. As the Central DBA, the candidate will operate as guidance and approval. As such, the candidate will need to be able to have excellent communication skills. Primary Responsibilities Analyze database requirements for OLTP and reporting and analysis applications. Responsible for the architecture of technical solutions for the databaserelated portions of IT projects. Design and construct databases. Develop methods for integrating different products such as customizing commercial databases to fit specific needs. Coordinate database development and determine project scope and limitations. Responsible for database provisioning and capacity planning for adequate database storage. Perform database backup and recovery using Oracle RMAN utility. Performing routine backups and restorations. Support Cloud Computation for Oracle/SQL Server databases. Perform data export and imports. Ensure integrity and recoverability of database structures. Responsible for database integrity of production databases. Develop operational procedures. Developing and implementing database administration policies & procedures including subsystem or instance security guidelines. Implement and maintain database structures and objects. Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software. Prepare and update documents of database standards, user manuals, procedures and processes, records, evaluations, schedule, project plans, reports, reviews, etc. Create and provide design artifacts for technical reviews of physical database models. Revise the company definition of data as defined in the data dictionary. Provide change management and documentation for database changes. Review periodic patches and new releases of Oracle software and implement the same in the CMS environment. Install and maintain a Real Application Cluster (RAC). Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems Install, configure, and maintain High Availability for Oracle databases. Migrate application data structures across multiple database platforms (such as SUN Solaris, IBM zLinux, MS Windows, etc.) Participating in database migration reviews. Migrate databases to different platforms, data centers, or AWS. Monitor and tune database environments for improved system performance. Provide query performance monitoring and tuning recommendations. Perform performance analysis and enhancement of SQL queries. Establish and calculate optimum values for database parameters, using manuals and calculators. Select and enter codes to monitor database performance and to create a production database. Responsible for the execution and monitoring of database utilities and scripts. Develop and test Oracle/SQL Server databases. Responsible for implementing or overseeing the implementation of all database programming. Develop and execute appropriate Data Definition Language (DDL) to support projects. Develop UNIX, Perl and other needed scripts to support applications and database administration functions. Test programs or databases, correct errors and make necessary modifications. Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions Provide guidance to database and application development personnel on the use and administration of Oracle and SQL Server DBMS software. Lead and conduct technical reviews of physical database models. Review project requests describing database user needs to estimate time and cost required to accomplish the project. Review procedures in database management system manuals for making changes to the database. Review and approve applicationbased scripts, utilities, stored procedures, functions, and triggers. Maintain quality of Oracle/SQL Server databases. Responsible for the databaserelated production release of project solutions. Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. Specify users and user access levels for each segment of the database. Responsible for the security and integrity of the database environment. Maintain database control standards for central database administrators. Review physical data models submitted in a CMSapproved format (currently: CA AllFusion) for design integrity and adherence to published CMS database standards. Utilize management tools (e.g. Service Now) to support database users service requests. Provide user support for data and databaserelated issues. Train users and answer questions. The scope of the services requires support during core and noncore hours. Core hours are 6 AM to 9 PM eastern time (ET). Noncore hours include the following categories of support: Emergency This is offhours (noncore hours) support for database problems such as database crashes, backup failures, slow performance etc.; and Scheduled (this includes upgrades and releases). Planned support for work that cannot be conducted during core work hours. Oncall support during noncore hours on a rotational basis. " Required Qualifications A Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline or a commensurate combination of a relevant degree and 15 years total experience. Oracle certification is preferred. Experience working in the database domain with at least 10 years of experience managing all operations of Oracle and SQL Server databases. Demonstrated skills in both Oracle and SQL Server Area of Expertise Tools / DBMS Features: Oracle 19c, Oracle 12cR2, Oracle Real Application Cluster (RAC) (1,2 Node), Structured Query Language (SQL), Oracle PL/SQL, SQL PLUS, PL/SQL, TSQL, Linux and Windows Sysadmin skills, Shell Scripting (Bash/Korn/C shell), Oracle RMAN, Oracle SQL Loader, Oracle DataPump, Oracle +ASM, Symantec/Veritas NetBackup, OEM Cloud Control 13c, Oracle Automatic Workload Repository (AWR), Oracle Automatic Database Diagnostic Monitor (ADDM), Oracle Active Session History (ASH), OEM SQL Tuning Advisors, TOAD, Oracle SQL Developer, Erwin Data Modeler, CA AllFusion, MS SQL Server 2012/2016/2019, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SSIS Packages
Job Description The Senior Database Administrator (DBA) will work within a pool of other Senior DBAs to support approximately 20 online transaction processing (OLTP) applications, online analytical processing (OLAP) applications, and decision support systems (DSS). The database environment consists of databases that range in size from several hundred gigabytes (GB) to several terabytesized databases. The database management systems are both SQL Server and Oracle, so the successful applicant will have experience with both environments. The Senior DBA pool will support these applications in both a localDBA and centralDBA model. As the Local DBA, the candidate will directly provide all database services, including programming, tuning, design, etc. As the Central DBA, the candidate will operate as guidance and approval. As such, the candidate will need to be able to have excellent communication skills. Primary Responsibilities Analyze database requirements for OLTP and reporting and analysis applications. Responsible for the architecture of technical solutions for the databaserelated portions of IT projects. Design and construct databases. Develop methods for integrating different products such as customizing commercial databases to fit specific needs. Coordinate database development and determine project scope and limitations. Responsible for database provisioning and capacity planning for adequate database storage. Perform database backup and recovery using Oracle RMAN utility. Performing routine backups and restorations. Support Cloud Computation for Oracle/SQL Server databases. Perform data export and imports. Ensure integrity and recoverability of database structures. Responsible for database integrity of production databases. Develop operational procedures. Developing and implementing database administration policies & procedures including subsystem or instance security guidelines. Implement and maintain database structures and objects. Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software. Prepare and update documents of database standards, user manuals, procedures and processes, records, evaluations, schedule, project plans, reports, reviews, etc. Create and provide design artifacts for technical reviews of physical database models. Revise the company definition of data as defined in the data dictionary. Provide change management and documentation for database changes. Review periodic patches and new releases of Oracle software and implement the same in the CMS environment. Install and maintain a Real Application Cluster (RAC). Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems Install, configure, and maintain High Availability for Oracle databases. Migrate application data structures across multiple database platforms (such as SUN Solaris, IBM zLinux, MS Windows, etc.) Participating in database migration reviews. Migrate databases to different platforms, data centers, or AWS. Monitor and tune database environments for improved system performance. Provide query performance monitoring and tuning recommendations. Perform performance analysis and enhancement of SQL queries. Establish and calculate optimum values for database parameters, using manuals and calculators. Select and enter codes to monitor database performance and to create a production database. Responsible for the execution and monitoring of database utilities and scripts. Develop and test Oracle/SQL Server databases. Responsible for implementing or overseeing the implementation of all database programming. Develop and execute appropriate Data Definition Language (DDL) to support projects. Develop UNIX, Perl and other needed scripts to support applications and database administration functions. Test programs or databases, correct errors and make necessary modifications. Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions Provide guidance to database and application development personnel on the use and administration of Oracle and SQL Server DBMS software. Lead and conduct technical reviews of physical database models. Review project requests describing database user needs to estimate time and cost required to accomplish the project. Review procedures in database management system manuals for making changes to the database. Review and approve applicationbased scripts, utilities, stored procedures, functions, and triggers. Maintain quality of Oracle/SQL Server databases. Responsible for the databaserelated production release of project solutions. Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. Specify users and user access levels for each segment of the database. Responsible for the security and integrity of the database environment. Maintain database control standards for central database administrators. Review physical data models submitted in a CMSapproved format (currently: CA AllFusion) for design integrity and adherence to published CMS database standards. Utilize management tools (e.g. Service Now) to support database users service requests. Provide user support for data and databaserelated issues. Train users and answer questions. The scope of the services requires support during core and noncore hours. Core hours are 6 AM to 9 PM eastern time (ET). Noncore hours include the following categories of support: Emergency This is offhours (noncore hours) support for database problems such as database crashes, backup failures, slow performance etc.; and Scheduled (this includes upgrades and releases). Planned support for work that cannot be conducted during core work hours. Oncall support during noncore hours on a rotational basis. " Required Qualifications A Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline or a commensurate combination of a relevant degree and 15 years total experience. Oracle certification is preferred. Experience working in the database domain with at least 10 years of experience managing all operations of Oracle and SQL Server databases. Demonstrated skills in both Oracle and SQL Server Area of Expertise Tools / DBMS Features: Oracle 19c, Oracle 12cR2, Oracle Real Application Cluster (RAC) (1,2 Node), Structured Query Language (SQL), Oracle PL/SQL, SQL PLUS, PL/SQL, TSQL, Linux and Windows Sysadmin skills, Shell Scripting (Bash/Korn/C shell), Oracle RMAN, Oracle SQL Loader, Oracle DataPump, Oracle +ASM, Symantec/Veritas NetBackup, OEM Cloud Control 13c, Oracle Automatic Workload Repository (AWR), Oracle Automatic Database Diagnostic Monitor (ADDM), Oracle Active Session History (ASH), OEM SQL Tuning Advisors, TOAD, Oracle SQL Developer, Erwin Data Modeler, CA AllFusion, MS SQL Server 2012/2016/2019, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SSIS Packages
Montgomery & Associates
Sacramento, California
Groundwater Modeler Montgomery & Associates (M&A) is seeking a full-time groundwater modeler to support our water agency clients for our growing team and portfolio of projects in California. This position will be associated with one of our two largest offices (Oakland or Sacramento). Our team is currently working approximately 50% in the office and 50% remotely. Our company of highly respected water resources professionals, headquartered in Tucson, Arizona, has been in business since 1984 and is growing, with recent expansions in the western United States and South America. In California, our team comprises 22 professionals located in 5 offices: Oakland, Sacramento, Monterey, Pasadena, and San Luis Obispo. This position will support projects and tasks throughout California, primarily related to the implementation of the Sustainable Groundwater Management Act. The role offers an exciting opportunity to work with an enthusiastic team of water resource scientists and engineers. Technical work duties for tasks and projects that focus on quantitative hydrogeology and groundwater resources management may include: Interpreting lithologic, hydrologic testing, depth-specific water quality, and borehole geophysical data Compiling, processing, and analyzing hydrogeologic data using spreadsheets, databases, GIS, graphing software, and computer programming Developing hydrogeologic conceptual models and water budgets Developing numerical groundwater flow and transport models Conducting pre-and post-processing of model inputs and results of predictive modeling runs and implementing model updates Managing groundwater model tasks and activities Preparing data summaries, presentations, and technical reports/memos Participating in client meetings/teleconferences to present program results and recommendations Qualifications: Graduate degree in hydrology, geology, water resources engineering, or a related field of study; course work in hydrogeologic data analysis, groundwater modeling, and computer programming Two - five years of professional experience outside of academia developing and applying groundwater models Proficiency with Microsoft Office, GIS software, and computer programming (e.g., Python, Scilab, FORTRAN, Octave, etc.) Experience with MODFLOW (including NWT, USG, OWHM, GSFLOW, MF6, etc.) and Groundwater Vistas Professional training in quantitative hydrogeology and groundwater modeling Understanding of regional hydrogeologic settings and water resource regulations such as the California Sustainable Groundwater Management Act Strong organizational and problem-solving skills and commitment to deadlines Excellent oral and written communication skills; ability to present technical materials succinctly to teams and clients U.S. citizenship or authorization to work in the United States (required) We are an employee-oriented company and promote a relaxed and supportive work environment. Many of our employees have been at M&A for decades. We provide a generous benefits package that includes: Competitive benefits and salary in a growing team-oriented company Performance bonuses Dynamic work environment with safety and technical training provided by the company Challenging and collaborative multidisciplinary projects On-the-job mentoring by senior professionals Medical, dental, and vision insurance Flexible Spending Account; Health Reimbursement Account Long- and short-term disability Life/AD&D insurance Vacation, holiday, personal, and sick leave Employer matching 401k retirement plan Monthly Base Pay Range: $6,500 - $8,500 Estimated Annualized Compensation Including Bonuses: $87,750 - $114,750 Compensation for qualified extra hours could further increase the estimate above. PI6c56c24a2aa2-4438
Groundwater Modeler Montgomery & Associates (M&A) is seeking a full-time groundwater modeler to support our water agency clients for our growing team and portfolio of projects in California. This position will be associated with one of our two largest offices (Oakland or Sacramento). Our team is currently working approximately 50% in the office and 50% remotely. Our company of highly respected water resources professionals, headquartered in Tucson, Arizona, has been in business since 1984 and is growing, with recent expansions in the western United States and South America. In California, our team comprises 22 professionals located in 5 offices: Oakland, Sacramento, Monterey, Pasadena, and San Luis Obispo. This position will support projects and tasks throughout California, primarily related to the implementation of the Sustainable Groundwater Management Act. The role offers an exciting opportunity to work with an enthusiastic team of water resource scientists and engineers. Technical work duties for tasks and projects that focus on quantitative hydrogeology and groundwater resources management may include: Interpreting lithologic, hydrologic testing, depth-specific water quality, and borehole geophysical data Compiling, processing, and analyzing hydrogeologic data using spreadsheets, databases, GIS, graphing software, and computer programming Developing hydrogeologic conceptual models and water budgets Developing numerical groundwater flow and transport models Conducting pre-and post-processing of model inputs and results of predictive modeling runs and implementing model updates Managing groundwater model tasks and activities Preparing data summaries, presentations, and technical reports/memos Participating in client meetings/teleconferences to present program results and recommendations Qualifications: Graduate degree in hydrology, geology, water resources engineering, or a related field of study; course work in hydrogeologic data analysis, groundwater modeling, and computer programming Two - five years of professional experience outside of academia developing and applying groundwater models Proficiency with Microsoft Office, GIS software, and computer programming (e.g., Python, Scilab, FORTRAN, Octave, etc.) Experience with MODFLOW (including NWT, USG, OWHM, GSFLOW, MF6, etc.) and Groundwater Vistas Professional training in quantitative hydrogeology and groundwater modeling Understanding of regional hydrogeologic settings and water resource regulations such as the California Sustainable Groundwater Management Act Strong organizational and problem-solving skills and commitment to deadlines Excellent oral and written communication skills; ability to present technical materials succinctly to teams and clients U.S. citizenship or authorization to work in the United States (required) We are an employee-oriented company and promote a relaxed and supportive work environment. Many of our employees have been at M&A for decades. We provide a generous benefits package that includes: Competitive benefits and salary in a growing team-oriented company Performance bonuses Dynamic work environment with safety and technical training provided by the company Challenging and collaborative multidisciplinary projects On-the-job mentoring by senior professionals Medical, dental, and vision insurance Flexible Spending Account; Health Reimbursement Account Long- and short-term disability Life/AD&D insurance Vacation, holiday, personal, and sick leave Employer matching 401k retirement plan Monthly Base Pay Range: $6,500 - $8,500 Estimated Annualized Compensation Including Bonuses: $87,750 - $114,750 Compensation for qualified extra hours could further increase the estimate above. PI6c56c24a2aa2-4438