| Database Manager at Remote, Remote, USA |
| Email: [email protected] |
| From: priyanka verma, Triwave Solutions Inc [email protected] Reply to: [email protected] Database Management and Business Intelligence Services Brief Description of Services: Services may include for on-premise or cloud platform: creating logical and physical data models, planning, designing, programming, converting, installing, training, implementing security, and maintaining database systems in stand-alone, integrated, or networked configurations, database administration, modification and upgrade including system performance analysis, database upgrading and performance tuning, data extract/transform/load (ETL), stored procedure development, query optimization and data migration, managing and monitoring production databases in an N-tier environment, automated routine backups and refreshes, and data recovery. Provide ongoing database support to help ensure operations of day-to-day functionality. Develop design documentation, test plans, user manuals, and operations plans and instructions. Developing and executing functional test plans for systems and applications, including developing test data sets and scenarios. Business intelligence (BI) services include the transformation of raw data into meaningful and useful information for business analysis purposes. These services are capable of handling large amounts of unstructured data to help identify, develop, and otherwise create and allow for the easy interpretation of these large volumes of data including dashboards. Identifying new opportunities and implementing an effective strategy based on insights can assist the State of New Mexico with policy, planning, and informed decision making. Expected typical skills in, knowledge about, and experience with may include: Any RDBMS or cloud specific database engines including, but not limited to: MS SQL Server, Oracle DBMS including engineered solutions and appliances, MySQL, DB2 and/or IBM DB2; including data modeling, stored procedures, indexes, triggers, data processing flowcharting techniques; Database structures, theories, principles, and practices; Managing, monitoring, designing, building, installing, configuring, and supporting database infrastructure servers; Database performance monitoring, management, tuning and troubleshooting; Applicable data privacy practices and laws and appropriate data masking techniques; Ability to conduct research into database issues, standards, and products as needed; Data entry operations including the ability to accurately enter information into a computer, accessing information from a computer, and verifying information on a screen; Data entry operations including duties utilizing automated equipment, including electronic keyboard, display screen, and sorted memory; Data entry operations including ability to operate and understand basic scanning and imaging equipment, including pan, skew, and image correction techniques; Supporting a wide range of business decisions ranging from operating to strategic business decisions. Strategic business decisions include priorities, goals, and directions at the broadest level; Data derivation/Data import from external data and from internal sources; Transforming raw data into meaningful and useful information, and developing and documenting algorithms. May include establishing a methodology and including any assumptions. Business Intelligence: Multidimensional aggregation and allocation; de-normalization, tagging and standardization; Business Intelligence: Establishment and design of object level design tools; Business Intelligence: Real-time reporting with analytical alert; interface with unstructured data source; group consolidation, budgeting and rolling forecast; Business Intelligence: Statistical inference and probabilistic simulation; Business Intelligence: Key performance indicators optimization; version control and process management; open item management; Business Intelligence: Providing historical, current, and predictive views of business operations; or Business Intelligence: Reporting, online analytical processing, analytics, data mining, process mining, complex event processing, business performance management, benchmarking, text mining, machine learning/predictive analytics, and prescriptive analytics. Keywords: business intelligence microsoft Delaware |
| [email protected] View all |
| Fri Jan 26 02:28:00 UTC 2024 |